Skip to main content

Run, rename, or delete saved queries

Your saved queries live in Saved in the Merchant Sheets pane. See how to run, refresh, edit, rename, delete, and restore a saved query, and what to do when a query needs editing.

B
Written by Bradley Taylor

Your saved queries live in Saved in the Merchant Sheets pane. Each one shows its name, data type, and when it last ran. Search by name or data type to find one.

Run a saved query to your sheet

  1. In your sheet, select the cell where the header row should go.

  2. In Saved, select the play button next to the query.

The table lands at that cell, linked to the saved query. To see more options, select the query's name. Its card offers Run to sheet, Insert as function, Refresh in workbook, and Edit in builder.

Refresh every table from one query

On the query's card, select Refresh in workbook. It reruns every table and formula in this workbook that uses the query. The card shows how many places that is, such as "Used in 3 places in this workbook." The button is unavailable when the query isn't used in the open workbook.

Edit a saved query

Select Edit in builder on the query's card. The query opens in the Query Builder, where you change it and select Save changes. Save a query covers saving changes and copies.

Rename a saved query

  1. Open the query's card and select Rename.

  2. Enter a new name and select Rename.

Tables and formulas that use the query keep working after a rename.

Delete a saved query

  1. Open the query's card and select Delete.

  2. Review the warning, then select Delete again to confirm.

Deleting a query used in the open workbook affects its tables and formulas:

  • Tables: Keep their data. When you refresh one, the pane offers to keep it as an unsaved query.

  • Formulas: Show #REF! until you restore the query or pick another one.

Restore a deleted query

Select a formula that shows #REF! for a deleted query. The pane offers Restore query to bring it back with its formulas, or Pick another to point the formula at a different saved query.

When a query needs editing

A saved query marked Needs editing uses something that's no longer available, such as a removed field. Open it with Edit in builder. The builder marks the step to fix. Fix it, then select Save changes.

Did this answer your question?