Auto-refresh Pivot Table upon opening

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?
 
D

Debra Dalgleish

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.
 
Top