I have a data file that is basically comprised 1 worksheet with raw data. It has roughly 108.000 rows of data.
I have probably 20 worksheets in the same workbook using Pivot tables looking at this 1 sheet of raw data.
The file is now about 93 MB. I can still work with it but it's slowing down.
What is the recommended best course of action? I have started making pivot tables in separate workbooks that point to the workbook with the raw data. Will this help keep the file size low?
Should I do a copy-paste of the raw data worksheet and just have that living as a single worksheet in its own workbook, and all pivot tables in separate workbooks looking at that 1 worksheet?
Bookmarks