 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2008Pivot table caused 50 MB excel file
I used more than 15 pivot tables in an excel file. It also have quite a lot of formulas. Though there is hardly much of data, file size has increased to 50 MB. In my quest to find out what caused this huge size, I deleted all the sheets one by one and observed that workbook with all the sheets deleted was 7 MB!! I am sure this is very common for excel to get heavy in size but any idea how to shrink/compress it back to normal? 1. Is it caching, which needs to be cleared? 2. I have already deleted all the not populated rows and columns to tell excel that data does not exist there!! what else can I do here? Are all the pivot tables based on the same data? If so, there's sample code here to change all the pivot tables to use the same cache: http://www.contextures.com/xlPivot11.html > I used more than 15 pivot tables in an excel file. It also have quite a lot > of formulas. Though there is hardly much of data, file size has increased to [quoted text clipped - 6 lines] > 2. I have already deleted all the not populated rows and columns to tell > excel that data does not exist there!! what else can I do here?  SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html Thanks, I would give this a try. But, it still does not explain 7.5 MB empty file, right? > Are all the pivot tables based on the same data? If so, there's sample > code here to change all the pivot tables to use the same cache: [quoted text clipped - 11 lines] > > 2. I have already deleted all the not populated rows and columns to tell > > excel that data does not exist there!! what else can I do here? The workbook must have at least one sheet left in it. If you press Ctrl+End, what cell is selected? Are there any shapes, names, code, etc., in the workbook? > Thanks, I would give this a try. But, it still does not explain 7.5 MB empty > file, right? [quoted text clipped - 14 lines] >>>2. I have already deleted all the not populated rows and columns to tell >>>excel that data does not exist there!! what else can I do here? SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html I could not find any solution to this huge file and I rather moved data to new file!! > The workbook must have at least one sheet left in it. If you press > Ctrl+End, what cell is selected? [quoted text clipped - 18 lines] > >>>2. I have already deleted all the not populated rows and columns to tell > >>>excel that data does not exist there!! what else can I do here? Hi, I'm having the same problem. I have gone to the website, but there is no instructions on how to change the pivot cache. Do you have a step by step instructions on how to go about it? I have a master data worksheet which is updated every hour, and several pivots in the file. Several other files are also linked to the master data worksheet. I'm trying to make the file smaller. It is now 29,000KB. Thanks, Karen > Are all the pivot tables based on the same data? If so, there's sample > code here to change all the pivot tables to use the same cache: [quoted text clipped - 11 lines] > > 2. I have already deleted all the not populated rows and columns to tell > > excel that data does not exist there!! what else can I do here? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.