Sheet File To Large due to Pivot Tables?

  • Thread starter Allan P. London, CPA
  • 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
 
P

Peter T

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

Pivot tables wont work in protected sheet? 3
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
Refreshing external data on individual sheets in a specific sequen 1
refresh multiple pivot tables in workbook 2
Pivot tables not refreshing after data source update 1
display pivot refresh date? 3
Pivot Tables - delete rows from Master List 2
Scenario/Pivot Tables 2

Top