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

kadina64
New Contributor

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.

 

kadina64_2-1621973874373.png

 

 

 

kadina64_0-1621973765020.png