To automatically update spreadsheet data:
- In the Database Manager, in Ribbon view, on the Home or View tab, in the Settings group, click Options.
- Or -
In Classic view, on the View menu, click Options.
The Options Dialog Box appears.
- From the View Options area, select Enable Spreadsheet Auto Refresh.
- In the Enter refresh period field, type in the refresh rate you want.
IMPORTANT: Be aware that for a large database, you should increase the refresh rate to 20 or more seconds. Do not use the default of 5 seconds for large databases. If you leave the refresh rate at low number, such as the default of 5 seconds, and you try to import a large amount tags, the database may appear unresponsive.
