| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I keep file sizes small when using multiple pivot tables?
I have a large spreadsheet of data (around 16mb) and I need to do lots of
pivot tables from that data. I have moved the pivot tables to a seperate workbook but the file size is nearly 100MB and this makes it pretty unusable. Is there any way to compress data in the pivot tables so you can still see the data but keep the files small? Cheers for any help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple people accessing an Excel file from a server at once. | Excel Discussion (Misc queries) | |||
| multiple worksheets in html - one file | Excel Discussion (Misc queries) | |||
| Multiple excel users can open the same file and edit at the same . | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| how do i sync multiple copies of the same excel file? | Excel Discussion (Misc queries) | |||
Threaded Mode
