View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Allan P. London, CPA Allan P. London, CPA is offline
external usenet poster
 
Posts: 11
Default 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