?
how do you update pivot table report data after changes are made to the source data?
Answer & Solution
Correct Answer:
Option
C
When changes are made to the source data of a pivot table, the pivot table itself does not automatically update.
To refresh the pivot table with the updated data, you need to click on the pivot table report.
Then, on the pivot table toolbar, you can find the "Refresh Data" button which will update the report with the latest data from the source.
Therefore, the correct method is to click the refresh data button, making Option C the correct answer.
To refresh the pivot table with the updated data, you need to click on the pivot table report.
Then, on the pivot table toolbar, you can find the "Refresh Data" button which will update the report with the latest data from the source.
Therefore, the correct method is to click the refresh data button, making Option C the correct answer.
Join the Discussion
Login to post a comment or share your explanation.
Login