Refreshing data after changes are made to connected Google Sheets and Excel Online databases?
Question
How does BarTender refresh data when changes are made to connected Google Sheets and Excel Online databases?
Applicable to
BarTender 2021 and later.
Answer
Google Sheets and Excel Online are both database connection types introduced in BarTender 2021. They operate with files that are saved automatically in the cloud.
This means that the database files you are using can remain open in either cloud environment while you access that data in BarTender. You can add or remove data in the cloud environments, save the changes, and BarTender will remain connected to those files.
To get your BarTender document to reflect any changes you make, follow these steps:
- Go to File > Database Connection Wizard
- Click the green Refresh symbol shown below, and the database connection will update.
Alternatively, you can simply close and reopen the BarTender document, and any changes made to your cloud files will show up.