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!

"carolyn" wrote:

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!