Hi
I've recently added some filters to some of my PT's in a workbook. My problem is, when new dates are added to the source data the tables don't show that new data unless I clear the filters then re-apply them. This is not ideal with so many pivot tables in the workbook.
Is there a setting I need to change or some other way of overcoming this problem? The below image shows two of the tables with their filters at the top.
pt.png
Bookmarks