What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed?

The correct answer to this question is to Refresh data. This technique would be used in the Microsoft spreadsheet software, Microsoft Excel. Refresh data allows one to refresh the data in an excel workbook from a connected data source. Those sources could be a cell range, text file, or Web query.

The steps for refreshing differ based on the connected data source. Each time the data is refreshed, the data source will show the most updated version. Any changes that are made will be reflected in the data source. For security purposes, the computer must allow the connected data source to view the updated versions.