Spreadsheet cell limits
回答済みHow 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!
3
Thanks Mike, that's very helpful and just the answer I was hoping for!
0
You'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.
0
Does 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.
1
Hi 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.
0
Hello - 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.0
Hi 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!
1
Hi 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.
0サインインしてコメントを残してください。
コメント
8件のコメント