Auto-refresh Pivot Table upon opening

  • Thread starter Thread starter K. Georgiadis
  • Start date Start date
K

K. Georgiadis

Over the past couple of days, I have been asking
questions about a macro that auto-refreshes a pivot table
upon opening it (meanwhile I have a macro that works).

Yesterday I noticed that the Pivot Table options (Excel
2002) provides an option "refresh on open." Does
selecting this option do exactly what I was looking for?
 
Yes, the "Refresh on open" setting will do what you want, unless the
worksheet is protected. If it is protected, you can run a macro when the
workbook opens, to unprotect, refresh, and protect.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for auto refresh 1
Run Macro Automatically When Excel 2003 Opens 2
Pivot Table Refresh 1
Column limit for Pivot Table data source 1
Pivot ungrouping on refresh? 3
Pivot Table Refresh not working properly 1
Pivot table and row heights 5
Refreshing a pivot table 1

Back
Top