A pivot table is not linked directly to its source data but instead is linked to a special hidden cache of the data.
When a change is made to the data the PivotTable is not updated automatically.

alt textRefresh Detail - Updates the data in a PivotTable or a PivotChart report if the source data has changed.

You can refresh the data at any time by clicking on the Refresh Button on the PivotTable toolbar or by using the shortcut menu.
You must refresh the pivot table manually by using the refresh button located both on the PivotTable toolbar and on the shortcut menu.
It is possible to update your pivot table automatically every time the workbook is opened. Select (PivotTable > Table Options) and select "Refresh on Open".
Can you refresh your data at regular intervals, does it refer to Excel data ??

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext