Refresh Pivots w/ Remote Data

[Arty-G]

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?

ActiveSheet.PivotTables("PivotTable2").RefreshTable
 
ActiveSheet.PivotTables("PivotTable2").PivotCache.Refresh

Thanks for all the help I've already received from this impressive forum! -Arty

[stapuff]

Arty -

In your macro you need to select the sheet with the pivot table that needs to be updated or you pivot table is not named pivot table 2.

Stapuff

[stapuff]

Arty -

Post your macro and names of the sheets and pivot tables.

Kurt

[tommy bak]

if you are able to refresh manually, the code should work.
If the name isn't correct it will fail. Try this instead, if you're not sure about the name.
Please change range("A3") to a cell inside you pivottable.

Private Sub Worksheet_Activate()
    ActiveSheet.Range("A3").PivotTable.RefreshTable
End Sub

br
Tommy Bak

[Arty-G]

Thanks, Tommy and Stapuff. I just needed to select my sheet. I appreciate the help!! - Arty