how to update a pivot table with new data?
Answers
Answered by
4
To do this: Select any cell in the Pivot Table. Go to Analyze –> Data –> Change Data Source. This will select the data source that you have used and will open the ‘Change PivotTable Data Source' dialog box. In the Change PivotTable Data Source dialog box, update the range to include new data. Click OK.
Hope it helps u
Similar questions