Worksheet Cell Calculation for Limit Example

This example provides guidance for calculating the cell count limit for a worksheet.

Note: Exceeding the cell count limit for a worksheet displays the worksheet cell count limitation message.

Beginning with a spreadsheet containing 2642 rows covering 16 months:

• The budget entry cells = 42,272 cells
• The additional minimum columns of data within the worksheet of the rows listed below = 15,852 cells
  • GL Code
  • Titles
  • Totals
  • Spread Totals
  • Description
  • Status

Grand total = 58,124 cells.

Adding a column with the same number of rows while increasing the months covered from 16 to 17 would increase the cell count total to 60,766 causing the worksheet cell count limitation message to display.