Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet File To Large due to Pivot Tables?
Folks,
The pivot tables on my project are taking an extra 2.5 MB when I save the file. I empty the data sheet and refresh the Pivot Tables with no data before closing the file and I made sure that the "Save data with table layout" is NOT checked. I have 11 Pivot Tables, each with a corrisponding graph. If I delete the graphs, I save about 1 MB, but they were carfully formatted and it would take a bit of code to duplicate using VBA. So, what is taking the extra 1.5 MB? Thanks for your help. APL |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet File To Large due to Pivot Tables?
What is the usedrange on each sheet after cleaning up, maybe you are not
removing cell formats incl row/col dimensions. 1mg for 11 charts seems a lot, each chart only comprises series formulas, formats etc, apart from the source data typically not much in the way of file size. Regards, Peter T "Allan P. London, CPA" wrote in message ... Folks, The pivot tables on my project are taking an extra 2.5 MB when I save the file. I empty the data sheet and refresh the Pivot Tables with no data before closing the file and I made sure that the "Save data with table layout" is NOT checked. I have 11 Pivot Tables, each with a corrisponding graph. If I delete the graphs, I save about 1 MB, but they were carfully formatted and it would take a bit of code to duplicate using VBA. So, what is taking the extra 1.5 MB? Thanks for your help. APL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file using pivot tables is too large | Excel Discussion (Misc queries) | |||
Can you save 1 sheet from a large file into another file? | Excel Worksheet Functions | |||
Multi-Sheet Pivot Table Too Large | Excel Discussion (Misc queries) | |||
large data file problems - pivot table with vba | Excel Programming | |||
Large Excel file size, no pivot tables | Excel Discussion (Misc queries) |