Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Active Cells by Worksheet

Request Demo

I have a workbook butting up against the 2 million cell limit.

When I manually review each sheet, I can only account for two-thirds of the cell count (select all, see what the 'count' says in the bottom righthand info pane).

Is there anywhere that Workiva will tell me how many active cells are in each worksheet so that I can target my clean-up?

0

Comments

3 comments

Date Votes
  • Hugh Hart

    Hi Peter! 

    In Spreadsheets every cell, blank or not, count toward your cell limit of 2 million. We recommend completely deleting out blank cells, columns or rows that you might not be using. 

    Let me know if there are any questions here. Our Workiva product teams 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.

    0
  • Lay Hoon Yap
    • Edited

    Hi Hugh,

    For blank cell if this is newly created without input any content before, it doesn't seem to count toward the cell limit shown in spreadsheet properties as I try to add new columns, the cell count does not increase. 

    I also observed that blank cells, only those that active before (input with content before) will be count towards the cell count as I try to delete the content of one column, the cell count does not reduce, only when I delete the column, the cell count reduce. Is there any way we can check those active cells but without content that count towards cell limit so that we can do clean up and fully utilize the cell limit?

    0
  • Isabel Messore

    Lay Hoon Yap,

    Any cell matching one of the following conditions below will count towards the 2 million cells per spreadsheet limit.

    • Any cell with a value
    • Blank cells with formatting applied
    • Any cell with previous input (cell history)
    Based on this, my initial thought is that the cells are deemed active due to things like cell history even though the content has been cleared. Authorship is the best approach here. Enabling it via the history panel will show the active cells. In theory, if you copied the spreadsheet that would remove those blank/active cells as well!
     
     
    0

Please sign in to leave a comment.