Refresh Connected (Imported) Data

A cell range, Excel table, PivotTable report, or PivotChart report can all be connected to an external data source. You can refresh the data to update data from this external data source. Each time you refresh data, you see the most recent version of the information in the data source, including any changes that were made to the data. Security Connections to external data may be currently disabled on your computer. To refresh data when you open a workbook, you must enable data connections by using the Trust Center bar, or put the workbook in a trusted location.