I have a worksheet that connects to a SQL DB. This worksheet has three pivot tables using the same DB connection. I would like to be able to change the parameter on all three by choosing one parameter. Any ideas would be greatly appreciated.
A little more detail. My first pivot table has a parameter in field B1, the second in field F1 and the third in field J1. I would like to be able to change the parameter in field B1 and have it update field F1 and J1
A little more detail. My first pivot table has a parameter in field B1, the second in field F1 and the third in field J1. I would like to be able to change the parameter in field B1 and have it update field F1 and J1
Last edited:
