You will have to click Refresh on the Analyze ribbon or click Alt+F5.
After a pivot table has been created, you would possibly want to feature new records within the source data, or change the present records. In an exceedingly large workbook, it may be difficult to locate the precise source for the pivot table, if there are several tables or lists.
Follow these steps, to seek out the information source of a pivot table:
Select any cell within the pivot table.
On the Ribbon, under the PivotTable Tools tab, click the Analyze tab (in Excel 2010, click the choices tab).
In the Data group, click the highest section of the Change Data Source command.
To learn more about PivotTable refer :
https://brainly.com/question/15214258
#SPJ10
