Do PivotTables update automatically when the source data changes?
- A Yes, immediately
- B No, they must be refreshed
- C Only on file open
- D Only if the source is a Table
Answer
No, they must be refreshed
Stale PivotTables showing old numbers is a common source of reporting errors. Basing them on an Excel Table at least keeps the range correct.





