right click on the pivot table in the workbook and select

Table options . . .

from the popup menu.

In the table options dialog, toward the bottom select the Refresh on open
textbox.

--
Regards,
Tom Ogilvy


"Jimmy" wrote:

I wanted to know how to auto refresh a pivot table on open from Access to
Excel?