Forum Discussion

Copper Contributor

Aug 13, 2020

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...

BI & Data Analysis

excel

SergeiBaklan

Diamond Contributor

Aug 13, 2020

felixws

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.

felixws
Copper Contributor
Aug 18, 2020
Thank you for the advice to Clear All empty regions, it definitely helped decreasing the file size!
- SergeiBaklan
  Diamond Contributor
  Aug 19, 2020
  felixws , you are welcome