Sunday, October 29, 2017

Refresh data in a PivotTable

Refresh data in a PivotTable

If a PivotTable in your workbook is based on external data, you'll want to update it from time to time to make sure you're looking at the latest data. In Excel Online, you do this by right-clicking anywhere in the PivotTable and clicking Refresh.

Refresh command on the shortcut menu

More about using PivotTables in Excel Online

No comments:

Post a Comment