The correct answer is D. All of the above.
To update a pivot table report data after changes are made to the source data, you can do any of the following:
- Save your changes, close the workbook, and then reopen it.
- Select the pivot table worksheet and press F9 on the keyboard.
- Click the report, and on the pivot table toolbar, click the Refresh Data button.
Option A: Save your changes, close the workbook, and then reopen it.
When you save your changes to a pivot table report, Excel automatically updates the report to reflect the changes you made to the source data. However, if you close the workbook without saving your changes, Excel will not update the report when you reopen the workbook.
Option B: Select the pivot table worksheet and press F9 on the keyboard.
Pressing F9 on the keyboard will update all of the pivot tables in the active workbook. This is a quick and easy way to update all of your pivot tables at once.
Option C: Click the report, and on the pivot table toolbar, click the Refresh Data button.
Clicking the Refresh Data button will update the selected pivot table. This is a good option if you only need to update one pivot table.
I hope this helps!