Question

If you would like a database to automatically update when you update your spreadsheet, you should _____ them. map export merge link

Answer 1

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.

Answer 2

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.