Thanks, Myrna.

I want to try your method. I believe the code is ActiveWorkbook.RefreshAll
but how do I put it in Workbook_Open event. I couldn't find how in the Help.
Instead I found that I can refresh via this method.
1. On the PivotTable toolbar, click PivotTable or PivotChart, and then click
Table Options or Options.
2. Select the Refresh on open check box.

But then when the workbook is open, user has the option to select Enable
refresh or Disable refresh. I don't want that option and want it automatic
refresh.

Can you give me steps how to put in Workbook_Open event?

Thanks again.

Best regards,
Julie