Refreshing reruns your Merchant Sheets tables and formulas with the latest data Merchant Sheets has synced from Shopify. You can refresh one table, every table from one saved query, or the whole workbook. Refreshing only reads data. Nothing in your workbook is sent anywhere.
Refresh from the ribbon
Select Refresh on the Merchant Sheets ribbon tab, then choose what to refresh.
Option | What it refreshes |
Refresh this block | The table or formula that contains the selected cell. Select a cell inside one first. |
Refresh this saved query | Every table and =MS.RUN formula in the workbook that uses the same saved query as the selected cell |
Refresh all | Every Merchant Sheets table and formula in the workbook |
Check data freshness | Refreshes nothing. Opens Data Sources, which shows when each store last synced. |
You can also select Refresh all on the pane's Home page, or Refresh on the result card after you run a query.
What happens to your table
Refresh writes the latest result into the same table, in the same place.
Rows: The whole table is cleared and rewritten, so if the new result is shorter, no old rows are left behind. If nothing matches, the header row stays.
Formatting: Your colors, number formats, and column widths stay.
Sync line: Updates to show when your store last synced.
Formulas: Custom functions such as =MS.RUN recalculate with the latest synced data.
After a refresh
The pane confirms what ran, such as "Refreshed 3 of 3 blocks and 2 of 2 functions." It also tells you if:
A formula shows an error. Select the cell to see why.
A table or formula belongs to a saved query in another workspace. It's skipped, and the pane names the workspace. Switch to that workspace to refresh it.
There's nothing to refresh yet. Run a query or insert a formula first.
Refresh doesn't sync Shopify
Refresh reads the data Merchant Sheets already has. Your store syncs on a schedule set by your plan. To pull new orders from Shopify sooner, start a sync first, then refresh. Sync schedule by plan covers both.
Workbooks don't refresh on their own
Opening a workbook shows the data from its last refresh. Refresh it when you want current numbers. The sync line on each table shows how current it is.
If refresh won't run
If you see Sign in again to run or refresh queries., sign in from the pane and refresh again. For other errors, see Add-in won't load or sign in.