Hi!
I have a file that looks like this:
- Data sheet with ~ 10k rows. The columns are things like month, model, various dates, cost, etc, about 60 columns.
- A sheet that has various pivot tables on it
- Various sheets that have slicers that are connected, so when you select something like month, all pivot tables and slicers are filtered by just that month, etc.
Then, there is a macro embedded (that runs whenever the data is filtered via a slicer) in the data tab that basically just filters the data tab (one column on the data tab is just true false) based on whatever slicer is selected. This is just designed so that if you select a certain model for instance, the data tab will automatically filter to show only that model.
But it takes a good 8 seconds each time you select something via the slicer because it has to filter the data tab.
But my question is: Is there a way to just make a pivot table that looks just like the data tab (10k rows, 60 columns)? So that if you filtered by a slicer it would just update the pivot table, just like how the pre existing pivot tables update? Or any other similar method?
Any ideas?
Thanks!
Bookmarks