Aug 13 2020 05:10 AM
Hi all,
I was working on a quite large Excel model and performed some ad-hoc data analyses with the integrated Pivot Tables and Charts feature. This Increased the file size from ~7MB to ~12.5MB and impaired the model performance. Even after deleting the Pivot Tables/Charts the file size and poor performance remains unchanged.
As far as I know, the data analyzed in the Pivot Tables is stored in a separate chache that is attached to the Excel file by default. Also, after turning off this option and saving again, the file size is unchanged. Is there any possibility to remove the Pivot cache i.e. reducing the file size to the "pre"-Pivot level of ~7MB?
Any help is greatly appreciated!
Best,
Felix
Aug 13 2020 08:22 AM
In general how to manipulate with Pivot Caches is here https://www.myonlinetraininghub.com/excel-pivot-cache, but if you remove PivotTables caches also shall be removed. Perhaps something else. You may try Clear All on currently empty regions.
Aug 18 2020 04:51 AM