Auto refresh pivot table

VAustin

New member
Joined
Apr 2, 2016
Messages
1
Reaction score
0
Points
0
Is there a way to set up a pivot table so that it automatically refreshes when data is changed?
 
Sort of...

For a Pivot connected to a database, you can set up a scheduled refresh by going to Data --> Connections --> Properties and selecting the "refresh every x minutes". But this only works for data that lives outside the workbook. It also doesn't care if the data is updated or not, as Excel has no way to know. Just be warned that if your data set is large, setting this number too low could leave you with performance issues as the data will be updated too frequently.

If the PivotTable is based on range of worksheet data, then you'd need a macro to kick off the PivotTable update. Can certainly be done, just takes a bit more work.
 
You can also select the "Refresh on file open" option. PivotTable Tools --> Analyse --> Options --> Data
Check 'Refresh data when opening the file'.
 
Back
Top