Sheet File To Large due to Pivot Tables?

  • Thread starter Thread starter Allan P. London, CPA
  • Start date Start date
A

Allan P. London, CPA

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
Pivot Table Question 2
Passing Criteria to a Pivot Table from combo boxes 3
Expand and collapse 2
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
Playing back a Pivot Table macros 2
Corrupt files due to pivot remnants after saving via VBA 0
Pivot tables wont work in protected sheet? 3

Back
Top