You can refresh a connected table at any time by opening the connected table and clicking Refresh Data on the Page bar.
You can also refresh a connected table automatically, on a monthly, weekly, daily, or hourly basis. The scheduled time is based on the app's timezone settings, which are set in App properties.
When you create a connected table, you choose when and how to refresh data in the table on the Refresh options page. App admins and the connection owner can change the refresh options any time.
To set or change refresh options:
-
Open your connected table and select Settings.
-
Click the Connection, for example, QuickBooks connection.
-
On the Details tab, locate Refresh options and then click Edit options.
-
Set or adjust the refresh options and then click Done. To stop a connected table from refreshing according to a schedule, select Manual only.
Tip: Before you change the refresh options, make sure you understand the purpose of the connected table.