ExcelBanter - VBA Excel Macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA Excel Macro (https://www.excelbanter.com/excel-programming/385075-vba-excel-macro.html)

Jimmy

VBA Excel Macro

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

Tom Ogilvy

VBA Excel Macro

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?

All times are GMT +1. The time now is 05:15 PM.