Pivot table - size of file?

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!