Forum Discussion
Pivot table filters reset when erasing or replacing data
I created a spreadsheet to track sales data which contains multiple pivot tables. I intend to save multiple copies of the sheet for individuals to use, then pull all the data into a master workbook....
If you don't add data to data model and don't use slicers it shall work. If something like this
Filtered PivotTable
Erased data and refresh
Update data and refresh