You have created a PivotTable and made some changes to values in the original dataset from which the PivotTable was created. How does this affect the PivotTable?
a.
The PivotTable is deleted from the workbook because it is not up to date.
b.
You must create a new PivotTable if you want updated results in a PivotTable.
c.
The PivotTable is updated automatically when you make changes to the dataset.
d.
Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.
Answer: d.
Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.
If the answers is incorrect or not given, you can answer the above question in the comment box. If the answers is incorrect or not given, you can answer the above question in the comment box.