If you would like a database to
automatically update when you update your spreadsheet, you should link them to
other file. You can directly link it with the external source.
If you would like a database to automatically update when you update your spreadsheet, you should link them. Links between them are needed so that values entered in one can be used in another. Linked data is only updated when the files are opened, unless you specifically click Data | Connections | Edit Links | Update Values.
