I have a spreadsheet that I have raw data and approx 40 pivot tables that I sort the raw data into. When I refresh all tables when new raw data is added, the label filter will not refresh and has to be manually refreshed. Is there any way to make the lable filter to refresh when all of the others do? Also when I send the file to others, they must reapply just that filter to see the data. I can post the file if needed.
Thanks
Chris
Thanks
Chris