Not sure if you want it to refresh every time you open the workbook or not.
If so, right click on the pivot table, select "Table Options", then select
"Refresh on Open"
The Refresh Every x Minutes option is only available when the pivot
table is based on external data. If your pivot table is based on a table
in Excel, you can refresh the pivot table manually, or use programming
to refresh it when the data changes.
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.
