You could refresh the pivot table when Sheet2 is activated.

Right-click on the Sheet2 tab, choose View Code, and paste the following
code where the cursor is flashing:

Private Sub Worksheet_Activate()
PivotTables(1).PivotCache.Refresh
End Sub


ShaneS wrote:
Hello
I am needing to write a code so that if I was to enter a value into a
particular column (say A:A) on one worksheet (named Sheet1), the PivotTable1
on another worksheet (named Sheet2) will refresh. I'm sure this will be easy
for someone out there!

Thanks in advance!

Shane.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html