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! |
All times are GMT +1. The time now is 09:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com