Spreadsheet cell limits
AnsweredHow do the cell limits work in Spreadsheets? I understand that there is a limit of 2,000,000 cells in Spreadsheets but I was wondering what counts as a used cell. Is it 2,000,000 cells containing any data or do empty cells count towards the limit as well?
As an example, I have deleted a column of 471 empty cells from one of my sheets, however the cell count only went down by 4 (from 1,814,546 to 1,814,542). There was no data in any of the cells that I deleted but the cell count still went down, however not by 471 like I was expecting.
I am looking for ways to reduce my cell count as I am nearing the limit but want to remove any 'unnecessary' cells first, if that is such a thing.
-
Hello and welcome, Carl!
The answer is any cell, even those that are empty, count toward your cell limit of 2 million. The best way to reduce down would be to completely delete out blank cells, especially so those that might be acting as a placeholder in your outline. By default, a new sheet will span to column Z and have 50 rows, so 1,300 cells (26 x 50). Deleting out unused columns can help here.
Let me know if there are any questions here. And our Workiva product team are looking into use cases of needs beyond 2 million cells, and they'd be happy to connect with your CSM to go over options and your current needs. Thanks again for your contributions and chat soon!
3Thanks Mike, that's very helpful and just the answer I was hoping for!
0You're quite welcome. I recently hit the 2 mill. limit on a Spreadsheet and found myself having get rid of blank columns, which did help.
0Does Workiva have any plans to increase the cell limit? We are also bumping up against the limit and have removed as many blank cells as possible.
1Hi Carl!
Off hand there's not any hard plans to bump up this limit, but that being said, it is possible for our engineers to increase the limit on a case-by-case basis. If you do wish to go beyond the 2 million limit, your CSM can reach out internally to start that process.
0Hello - I landed on this post when investigating my own cell limit issues - is the above statement of 'any cell, even those that are empty' still the case?
When I insert a new worksheet the cell count of my workbook does not change. When I add something to one cell, the count goes up by one.0Hi Peter,
I just answered this in your other post but yes, this is still the case. The cell count that you are looking at is cells that have values in them, not a count of the total cells. Let me know if you need anything else!
1Hi Hugh,
Thank you for mentioning the other post. The other one gave me clear instructions on how to remediate a recent issue related to cell limits.
0Please sign in to leave a comment.
Comments
8 comments