Synchronise new data from a data source

Introduction

Use this article when new data has been uploaded to a data source and needs to be applied to the linked tables in your document. When new data is available, the Synchronize button is marked with an exclamation mark.

Summary

After following these steps, the latest data from the selected data source is synchronized and all linked tables in the document are updated.

Steps

1. Open the document.
2. Click the Synchronize button marked with an exclamation mark.
3. Review the available data sources in the synchronization pop-ip.
4. Verify which data source contains new data by checking the Updated and Last synchronized timestamps.
5. When needed you can deselect data sources that you don't want to synchronise.
6. After reviewing the data sources, click the synchronize button the bottom left.
7. Wait for the processing to be done.

Then after the progress bar turns to green:

1. Review the synchronization results.
2. If synchronization errors are reported, identify the affected tables.
3. Verify whether the linked table, worksheet, named range, or other data source element still exists in the latest uploaded file.
4. If the data is no longer required, disconnect the affected table from the data source.
5. If the data should still be available, verify that the correct file was uploaded and upload an updated file if necessary.

Remarks

• Synchronization errors can occur when linked data is no longer available in the latest version of the data source.