You will have to write a macro that runs, say, when the workbook is opened,
that refreshes the table(s). The code would go in the Workbook_Open event
macro.


On Tue, 16 Nov 2004 18:06:29 -0800, "Julie"
wrote:

Good day everybody,

I would like to know how do I make the Pivot table in my Excel file
auto-refresh data when the file is open? This will ensure that my users see
the latest data without having to manually run the refresh data option.

Thanks in advance and have a nice day.

Best regards,
Julie