I have a file with about 8,000 rows of data and about 30 columns. I have
about 26 pivot tables that are in one of the sheets. The file is over 13MB.
If I delete the pivots my file size drops to only 6MB.

My question is, A) how much space does a Pivot Table take in a file, is it
the full size of the data it refrences? B) Is there a way to reduce the
amount of file space of the Pivot Table?

Any help would be much appreciated as a 13 MB file is very unwieldy to
update and manipulate when opened, and the file just gets bigger every month.
Thanks!!!