Forum Discussion
Excel inflated file size caused by PivotTables - How to reduce file size after removing all Pivots?
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 a...
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.
Thank you for the advice to Clear All empty regions, it definitely helped decreasing the file size!
felixws , you are welcome