Hi,

I have about 15 pivot tables on my worksheet with the same setup. When I want to filter on year I need to adjust each pivot seperately.

Is it possible to only change the year of one pivot so that the other pivots will also only show this year?

Thanks in advance.