Pivot table - size of file?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I recently had to change a pivot table from pointing to an Access query to
pointing to a table (same data though) and the size of the Excel sheet
containing the pivot table has become enormous - too big to work with. Any
ideas? Thx!
 
Nevermind, i got it! The .xls contained many pivot tables, and I changed
each one. It turns out they were all copies of the same on on different tabs,
so I updated one & pasted it over the rest - my file went back to a mangeable
size!
 
You must log in or register to reply here.

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

Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table - Changes 5
Pivot tables - memory issues - please help 2
about pivot table 1
Adding to an existing Pivot Table 7
pivot table space question 1
Pivot Table file size 4
Easy way to change Pivot table source files? 5

Back
Top