I have an Excel file with several tabs, one of which has two PivotTables. The data source for the first table is a specific range of rows (not an entire column) and the second table is based on the first. The size of the file is ~12 MB. If I remove this tab with the PivotTables the size goes down to ~1 MB.
I have two related questions:
- How can I select specific columns for the PivotTable in the data source? When I tried to do this in the Wizard I got a "Reference is not valid" error.
- Are there any other methods to reduce the size of the file? It seems ridiculous that a file would increase 12-fold in size because of this tab.
Thanks a lot.