auto refresh on pivot table

Hi me again,

i have an auto refresh code for a pivot table, but it only works if i use the tabs at the bottom, and not when i hyperlink to it. is there a way it will refresh when hyperlinked to the sheet?

Hi,

The problem with the hyperlink not firing the worksheet_activate event was fixed in XL2002 but does not work in XL2000 ...

HTH
Carim

ok Carim, thanks anyway

Hi again,

To trap hyperlinking which does not fire worksheet_activate event, JimCone has found a solution ...

In your workbook open event place something like this,
for each desired sheet ...

Sub FixItUp() 
 Me.Worksheets("Sheet3").OnSheetActivate = "DoThis" 
 Me.Worksheets("Sheet3").OnSheetDeactivate = "DoThat" 
End Sub

In your workbook close event use code like this for every
sheet listed above ...

Sub UndoFix() 
 Me.Worksheets("Sheet3").OnSheetActivate = "" 
 Me.Worksheets("Sheet3").OnSheetDeactivate = "" 
End Sub

DoThis and DoThat are the subs that run when the applicable
sheet is activated/deactivated. Place those subs in a general module.
Any of the sub names can be names you choose ...

HTH
Carim