Question

As you are working with a pivot table, you decide to change some of your source data. How will the pivot table recognize the change?

Select an answer:
Pivot tables adjust automatically to any changes made in the source data.
You will either have to click Refresh on the Analyze ribbon or click Alt+R.
You will either have to click Refresh on the Analyze ribbon or click Alt+F5.
You will have to save the worksheet, close out of it, and then reopen the worksheet.

Answer 1

To update a pivot table with changes made to the source data, you will either have to click Refresh on the Analyze ribbon or click Alt+F5.