Greetings!

My Excel file contains a few dosen pivots.

Every week I manually filter the current week (week 1, week 2 etc) option in all pivots.

Is there any way to set a global control option to change all the pivots at once?

Thanks!