Hi,
I hope there is someone that can help me with another question
regarding refreshing Pivot tables

I have a spreadsheet with:
-Some worksheets storing lookup information and a data input sheet
-A worksheet containing pivot tables showing results from the input and
lookup sheets
-A report worksheet with a summary of the data using Vlookup on the
Pivot tables worksheet, and performing additional calculations on this
pivot table derived data.

Whenever someone uses the report worksheet the data should be refreshed
from the Pivot tables as this is going to be a shared workbook with
possibly only one or two users occasionally entering data.

Have already tried solutions given to other's peoples questions without
success yet and don't know what I'm doing wrong (am using Excel 2000)

Have tried putting the following in "ThisWorkbook":

Option Explicit
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
ThisWorkbook.RefreshAll
End Sub

Am an Excel VBA newbie... Am also using Excel 2000 so wasn't sure if
this was the reason that this does not work.

Many thanks.

Regards,
David