Refresh Pivots w/ Remote Data

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

Code:

---

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

---

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

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

Arty -

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

Kurt

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.

Code:

---

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

---

br
Tommy Bak

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