I set up some pivot table templates in an excel file and I want to share the file with some people, the problem is even though I deleted all of my raw data if they look in the pivot table filters, some of the data is still there.
How can I get that data to be removed from the pivot table when they look at the filters, but they are still able to use it as a template when they dump their data in , if that makes sense
How can I get that data to be removed from the pivot table when they look at the filters, but they are still able to use it as a template when they dump their data in , if that makes sense