I have one spreadsheet where I'm unable to make new queries without it taking 5+ minutes to fetch data for. It doesn't matter how small the query is. this spreadsheet has many tabs so I thought it had something to do with the limitation to tabs in google sheets. However, I had another previous spreadsheet that had about the same volume of tabs where I am still able to make queries with no problems.
This issue seems to be contained to just this one particular spreadsheet.
sorry to hear about your issue. For us to investigate this, could you please give email@example.com a temporary edit access to the file and send us a link to it as a reply to this email. Mark the queries with the issue for example by changing the colour of the cells in to red.