pivot table refresh
 

No, you would us the workbook_Open event to execute the command

Worksheets("sheet1").PivotTables("PivotTable1").Re freshTable


See Chip Pearson's page on Events for an explanation of the Workbook_Open
event

http://www.cpearson.com/excel/events.htm


--
Regards,
Tom Ogilvy



"Valeria" wrote in message
...
Dear experts,
I would like to refresh a pivot table upon opening of the
workbook where it's contained.
I guess it must have something to do with the

Private Sub Worksheet_PivotTableUpdate(ByVal Target As
PivotTable)

but I really can't figure out how I have to use this!
Many thanks in advance.
Kind regards,
Valeria