Hi
I have multiple Pivot tables in a workbook, and some users are using the filters on top of the columns to search for their respective data, which is all find. But sometimes they save the files and the next person to take it has to find the filter (on top of columns) and clear these to find all the data. Is there a way to clear these user filters on opening of the workbook?
I only want to clear the ones that the user entered and not the ones that I have entered in the Pivot field data tabs.
Thanks
I have multiple Pivot tables in a workbook, and some users are using the filters on top of the columns to search for their respective data, which is all find. But sometimes they save the files and the next person to take it has to find the filter (on top of columns) and clear these to find all the data. Is there a way to clear these user filters on opening of the workbook?
I only want to clear the ones that the user entered and not the ones that I have entered in the Pivot field data tabs.
Thanks