If you change the underlying data in sheet DATA and/or sheet TB, the PivotTable is not updated automatically. You can update the PivotTable report by refreshing it in the following simple way:
1. Click any cell within the report.
2. Right click.
3. A floating menu will appear.
4. Select Refresh data. The report will be updated.
No comments:
Post a Comment