Update data

Since the data in the external document may change, it is recommended to periodically update the reference to this data in the current document.

To update the references after opening the current document, click the Refresh data button in the notification line "Linked documents might have changed. Refresh this document to get the latest data." This line is displayed under the Toolbar.

The application will recalculate formulas and functions taking into account new values from an external document.

If the document is not available, the notification line "Linked documents are unavailable. The spreadsheet uses the last saved data." Click the Close button in this line.

To update the data when working with a document, do one of the following:

•In the Data tab, click Refresh data.

•When working in macOS, select the Data > Refresh data command from the command menu.

•Press Ctrl+Shift+F5 (Windows, Linux) or Shift+ Cmd+F5 (macOS).

Data on external references are updated automatically when a new document reference is created or when an existing one is edited. In this case, the data is updated only for those documents that are specified in the created or edited formula.

#REF! error is displayed in cells in the following cases:

•When creating a reference, the external document specified in the reference is unavailable (or the specified sheet does not exist in it), and there are no previously saved values for it.

•When uploading a document, there are no saved values for the external document specified in the reference (the data was not received when creating the reference).