 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006How to reduce size of pivot
I have a pivot table and it size is very large say 50 MB and it uses an access database which is 300 MB to create it.Is there any better way of doing it?As I really want to reduce the size of pivot. Do you really need to interrogate all the data you are, or can you restrict it wrt columns or fields etc. Do you have multiple Pivot tables, and if so have you based them on an existing pivot table, as this could make a significant difference to your file size. Example, when you create a Pivot table, it will be far more fficient if you then copy the worksheet and then just edit the Pivot table as opposed to creating from scratch and not linking to an existing table.  SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------- It's easier to beg forgiveness than ask permission :-) > I have a pivot table and it size is very large say 50 MB and it uses an > access database which is 300 MB to create it.Is there any better way of > doing it?As I really want to reduce the size of pivot. I can not reduce /restrict any of the data fields . I was thinking at another alternative.Is it possible to create a data cube and then create pivots from these?Will it reduce the size?Any documentation on cubes and pivot? Thanks > Do you really need to interrogate all the data you are, or can you restrict > it wrt columns or fields etc. [quoted text clipped - 16 lines] > > access database which is 300 MB to create it.Is there any better way of > > doing it?As I really want to reduce the size of pivot. Try unchecking the PivotTable option: Save data with table layout. This means the data behind the pivot is not saved with the file and can dramatically reduce file size > I have a pivot table and it size is very large say 50 MB and it uses an > access database which is 300 MB to create it.Is there any better way of > doing it?As I really want to reduce the size of pivot. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.