Sir Babydum GBE
04-25-2008, 04:50 AM
I know I can't use a named cell in a pivot table calculated field.
But how do I get a macro to refresh a pivot table, and while it's at it, update the calculated field called "target" usiing the value in a cell named TG?
So where the code says:
ActiveSheet.PivotTables("PivotTable3").CalculatedFields("Target"). _
StandardFormula = "=12.17%"
I want the code to change the 12.17% to whatever value is in the cell named TG.
Thanks
But how do I get a macro to refresh a pivot table, and while it's at it, update the calculated field called "target" usiing the value in a cell named TG?
So where the code says:
ActiveSheet.PivotTables("PivotTable3").CalculatedFields("Target"). _
StandardFormula = "=12.17%"
I want the code to change the 12.17% to whatever value is in the cell named TG.
Thanks