View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rw9049 rw9049 is offline
external usenet poster
 
Posts: 1
Default pivot table space question

I have a pivot table with 3 months of data which takes up about 44M bytes.
I want to use this spreadsheet as a template to create a new spreadsheet
with a pivot table for the next month's data.
When I do this the new ss had roughly the same size as the 3 month ss.

Since I only have 8K rows in the new ss versus 24K rows in the old ss, I
would have thought the new pivot table would be somewhat smaller as far as
bytes.

Any ideas? Thanks