Applying one Pivot Filter to multiple cloned connections with the Excel Addin


I have one Excel workbook with multiple worksheets and I want to apply one Pivot value filter (e.g. Time - May 21) to all the worksheets. Rather than updating each individual worksheet "Time Value"....


When I used reference this value across worksheets it is blown away after the refresh.