How to set a Query to refresh on an fixed/absolute cell?

As an example, I would like my query to only refresh on the range Sheet2!$B$1:$B$1 . The problem I am facing is that on my spreadsheet, I will always insert a new column to the left of column B, and when I refresh the query after that, the query's address range will automatically update to Sheet2!$C$1:$C$1. How can I set a query to refresh only on an fixed/absolute cell which does not change when I insert new column?


  • Hi Derek,

    unfortunately it's not possible to work around the automatic refresh of the query position. Only way to do this is to change the query location manually before refreshing.

    Best regards,

    -Supermetrics Team

Login to post a comment