Start a new topic

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?


1 Comment

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 or Signup to post a comment