Slow Google Sheet

I have a Google sheet that’s taking ages to calculate, so the apps can’t read it at the moment.
It was working until I cleared some data (to make it quicker).
I think it’s because thee are some COUNTIFS and MAXIFS across the table.
Will it keep sorting itself out then eventually the apps will be able to read it again?
Or do I need to leave it open in a browser so that it calculates everything and then appsheet can read it?

1 Like