So we have a report that we pull in sales data into few times a week. Currently only has 2 months worth of data and already 359k rows. Now from that raw data we have about 12 give or take tabs that are just pivot tables of that data to make key areas easy to analyses when needed. Because everything is all within the file, the 2 month file has grown to 240mb and takes about 2 minutes to open.
So i have a few questions
Would splitting the data into 2 file help? (one for just the raw data and one for all the pivot tables)
Currently the raw data is stored as a named table and all pivot tables have been updated to all point to the same table (this helped reduce the file size)
Since the data is just going to keep growing, what options do we have to make this a little more efficient to work with and open quicker?
I copied just the raw data, no formatting and no formulas and those 359k records created a 68mb file, but that one opens in like 10 seconds, so would it make any difference in creating a file that is just all the different pivot tables that all point to that data file?
Just looking for ways to improve or upgrade this overall process to make it user friendly.
Bookmarks