3 ms·

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 s

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!

hyperbovine 8y ago
Have to ask, what is the use for such a Frankenstein?
richjdsmith 8y ago
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?
- prepend 8y ago
  Spreadsheets are a DB. Do you mean over a DB server? Or a relational DB? Or a DB without a bundled Model view controller?
- ramraj07 8y ago
  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.