I'd read online that Google sheets has a max cell limit of 5 million cells. A sheet that I'm currently working on has well and above passed that limit (including blank cells).
- What is the new limit?
- Also I'd manually checked how many cells I was using. Is there any function or script that I can use to keep a check?
- The sheet I'm working on is going to only get bigger and it's already lagging heavily. I'd love some suggestions on which platform I could move to next to handle such big data. There are so many options, it's mindboggling. I use Google sheets mainly for it's ease in collaboration, presentability and ease of use. Any other tool with these traits but with an ability to handle bigger data?
CodePudding user response：
in the early years, it was 5 million cells. last year this was upgraded to 10 million cells
you can follow updates at: 
This reads: "An error has occurred: This action would increase the number of cells in the worksheet above the limit of 10000000 cells".
However, when I used one more digit, I got a different message:
That one reads: "Oops, enter a number between 1 and 5000000", suggesting the maximum number of rows you can have is 5 million, while the max of cells can be up to 10 million. I'm not sure about the columns, but I'd say it is the as the row's limit.