Arty-G
07-07-2004, 07:45 AM
I am trying to apply the solution provided in the "Solved: Auto Refresh Pivot Table..." thread. However, my data is in a separate worksheet from my pivots. Neither of the two methods I've tried (below) are cutting it. I think I just need to point the connect property of my PivotCache to my worksheet, but I don't know quite how to do that. Ideas? :dunno
ActiveSheet.PivotTables("PivotTable2").RefreshTable
ActiveSheet.PivotTables("PivotTable2").PivotCache.Refresh
Thanks for all the help I've already received from this impressive forum! -Arty
ActiveSheet.PivotTables("PivotTable2").RefreshTable
ActiveSheet.PivotTables("PivotTable2").PivotCache.Refresh
Thanks for all the help I've already received from this impressive forum! -Arty