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?
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.