LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default Pivottable Size (very large from 25mb to 5mb)

Hi,
I'm wondering about the pivottable Cons? I've noticed in my spredsheet that
the size of it is rather large (25mb). So i was looking at ways to reduce
the size and noticed that there wasn't much diff by making all the formulas
values. Then i try deleting different sheets and didn't notice right away
any big jumps. that is until i deleted all the Pivottables. I have 3
pivottables with different data sources (same WS). I noticed that no matter
what the file size jumps from ~25 to 5 if i delete all 3 PT's. If i delete
any one there isn't much change, The change only occurs when you delete ALL 3
of them.

Has anyone had any experience with this kind of situation?
Is there a way to reduce the size of the PT's?

Thanks,
Josh

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to determine what is causing large size Dave H Excel Discussion (Misc queries) 1 August 7th 09 08:40 PM
Large File Size Paula Excel Discussion (Misc queries) 3 October 13th 08 10:44 AM
Excel file size too large skoolmarm Excel Worksheet Functions 1 July 9th 07 07:31 AM
Is there a way to find the source why the doc size is so large? Erinayn Excel Discussion (Misc queries) 1 October 26th 06 03:59 PM
why is the size of my file so large? stevej12 Excel Discussion (Misc queries) 2 May 24th 05 05:38 PM


All times are GMT +1. The time now is 01:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"