My Excel file contains many pivot tables and the tables often get corrupted because the files are so large. Is there anything I can do to remedy this?

Md Ariful Islam

0 like 0 dislike
1 views
Share with your friends

1 Answers

Dr. Md Rushad Rahman

Call

Make sure you are not saving the source data with the pivot table. Go to Pivot Table Options --> data tab --> uncheck "Save Source data with file." The pivot table will not update again without being refreshed because it needs to re-read the source data to refresh, but this will reduce the file size.

1953 like 0 dislike
1 views
Talk Doctor Online in Bissoy App
Can the corrupted files be recovered using data recovery software?

No. The data is not locally stored, therefore recovery software won't have trace files to recover from. As long as you are not handing in your laptop, you should be...

2 Answers 1 views
Is it possible for the recipient to tell that the file was deliberately corrupted?

If you have a Mac, yes. Clicking will get info on a file, the link the URL of the website the corrupted file is downloaded from in the "where from"...

2 Answers 1 views
How do I convert an MP4 file into an audio file so I can copy the audio file onto a CD?

1.) Choose an .MP4 video or any other supported media file from your device or cloud storage. 2.) Select ".mp3" as the conversion format from the dropdown menu. 3.) Click...

2 Answers 1 views
I need distinction between "media file" and "clip". I expect several clips from each file to be listed in a clip bin, not a media bin. And to be selectable there for adding to timeline.

A clip is a section of video or audio from a film or audio track whereas a media file is an overall description of any item that comes under the...

2 Answers 1 views
Once I locate the backup, how do I view it? My PC is asking how I want to open it, but I don't know which application to use because I do not know what the file contains. What do I do?

There's no way you can open the backup with Explorer or using iTunes, only with third-party backup browsers. iMazing is good (at least I didn't have any issues with it...

2 Answers 1 views
I'm in secondary school and my room looks like a 4 year old's room! I've got loads of toys from my elder siblings and I have pink butterfly wallpaper that is actually really childish. I'm not allowed to do anything with the wallpaper though because my parents can't afford it. What can I do?

You can start by decluttering your room! Take the toys out or anything that looks too childish. If your parents won’t let you sell or donate them, pack them away...

2 Answers 1 views
There's this girl I like but she says she wants to make sure of how she feels for me. And now she says she can't love me because I'm too emotional and I get moody, so I don't know what to do. Any advice?

I'd recommend you get to know her better. But before that, get to know yourself. You have to understand what she meant by "emotional" and "moody. For example, it might...

2 Answers 1 views
I have Microsoft Office 2008, and I only use excel.I Updated to Catalina today and can't open Excel. What now?

Open >App Store, and search "Excel." Then, you download that version, since it will be the newest version, which will be compatible with Catalina.

2 Answers 1 views