reduce size of pivot table file

Z

zapadias

I created a pivot table that draws on a very large set of data - the file is
7MB. I have since removed most of the data and slimmed the table down to only
10% of what was referenced before. The file is still 4MB. The table or
worksheet still seems to contain some data/links that it no longer needs. I
have removed all the fields and refreshed but this doesn't work.

I have another file that contains the same quantity of information and a
pivot table, but it's only about 200kb. WHY?!?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

200KB versus 35MB 0
Excel 2007 pivot table using analysis services cube as data source 0
Slicers and Calculated Items in Pivot Table 2
Reduce image size 0
Easy way to change Pivot table source files? 5
Pivot Table - Row Label Combination 0
Single Filter to change all Pivot Tables in a Workbook 9
How to combine two column labels in a pivot table 1

Top