Pivot filters lost

Hi all,

I have made a dashboard consisting of pivot tables filtered by day of the week. I wanted to have a master copy that I could dump data in from an external source.

When I remove the data used to create the pivots and replace with the new weeks data, the filters are lost and I have to manually filter again.

I had basically filtered out blanks and filtered Monday to Friday.

Is there a setting to keep the filters in place?

Thanks

S

Sknight consider sending sample data with any question you have, it makes our job 10 times easier

Consider changing source by week https://www.screencast.com/t/dCob23LIx or

ensure you have source data in table then merely extend and add to that table weekly and then filter the pivot table for the week under review https://www.screencast.com/t/tWQbPY6t

Note always send sample data!

cross posted without links:
https://www.mrexcel.com/forum/excel-questions/1041237-pivot-table-filters-lost.html
https://windowssecrets.com/forums/showthread.php/195541-Lost-filters-in-pivot-table

sknight22, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184