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 ...

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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