Good Morning All!
So I have a pivot table connected to a database.
Now I have three pivot tables, one for Year to date, month to date, and week to date.
Now its a huge database so it takes a good half an hour for each pivot to update.
Problem is that the person has to come back to the sheet to do MTD filter and then again after the long wait to the WTD Filter.
Is there anyway to set it so that the person can choose the dropdown filters for all three pivot tables first and then click a button (macro) so that it refreshes each filter based on the chosen dropdowns one after the other automatically.
Then someone can literally choose the filters and go grab a cup of coffee or something instead of waiting on one to finish after another.

This would be super helpful.
Thanks!!!