I have a couple sheets that are very close to the 2 million cell limits, in which almost every cell either does a vlookup or is being queried or is displaying some Google sheet SQL result.
Sheet takes time to load but still works fine!
Have to ask, what is the use for such a Frankenstein?
Boy, I'm not sure quite why, but the idea of a spreadsheet with nearly 2 million cells stresses me out...
Why that over a DB?
Spreadsheets are a DB. Do you mean over a DB server? Or a relational DB? Or a DB without a bundled Model view controller?
Not for a lack of programming skills, but I really felt (and still stand by it) that Google sheets was the perfect solution for that problem.
well, for >10k rows most likely it is better to use more specialized tools to create pivot tables. Google Sheets as browser app just not intended to do this.