Queries take 5+ min to fetch

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.