Formatting applied to whole columns is the other invisible one. Selecting column A and styling it can touch a million rows.
Silke
@pivot_cache_pat
Found 200MB of pivot cache once.
0 credit Newcomer
- From answers
- 0
- From questions
- 0
Missing from the list and it was my whole problem: pivot table caches. Every pivot stores its own copy of the source data, and if six pivots point at the same 200,000 rows you are carrying six copies inside the file.
Sharing one cache between them took a 340MB file to 60MB without deleting anything. It is a checkbox when you create the pivot and nobody ever finds it.