The idea of this process is to keep the data always up to date without having to repeat it every time the data source is modified. To update the data you simply have to tell Excel to refresh the data source.
In Windows, to update without problems, we must go to the connection iceland phone number library properties and uncheck the box that asks for the file when updating.
Disable file selection
Disable file selection
To do this, go to the Excel data tab and select the Update All option. After a few seconds, the data will be updated.
Update Data
Update Data
If you make a change in the Google Spreadsheet and go directly to Excel and there are no changes when you refresh, it is because the Spreadsheet takes approximately 5 minutes to update the publication. But there is a trick and that is to close and reopen the Spreadsheet (or refresh the page) and the changes will have already been saved in the publication.
You can also activate the option to automatically update the data every X time or when opening the file from the connection properties.
Connection Properties
Connection Properties
This way we can now link our Google Spreadsheets and w