|
Name
|
Description
|
Compatibility Mode Behavior
|
| Sheet exceeds limit for cross-sheet array formulas. | Excel 2000–2003 allows up to 65,472 cross-sheet array formulas. Excel 2007 removes this limitation. | Formulas over the Excel 2000–2003 limit return #VALUE. |
| Cell with a formula that exceeds internal length limit | Excel 2000–2003 allows up to 1800 bytes in BIFF8 internal representation. Excel 2007 allows up to 16,384 bytes. | Formulas over the Excel 2000–2003 limit return #VALUE. |
| Cell with a formula that exceeds nesting level limit | Excel 2000–2003 allows up to 7 levels of nesting. Excel 2007 allows up to 255 levels of nesting. | Formulas over the Excel 2000–2003 limit return #VALUE. |
| Cell with a formula that exceeds limit for arguments in a function | Excel 2000–2003 allows up to 30 arguments. Excel 2007 allows up to 255 arguments. | Formulas over the Excel 2000–2003 limit return #VALUE. |
| Cell formula contains more than 40 operands. | Excel 2000–2003 allows up to 40 operands. Excel 2007 allows up to 1024 operands. | Formulas over the Excel 2000–2003 limit return #VALUE. |
| PivotTable with only intermediate levels hidden | Excel 2000–2003 hides levels all the way up to the top. Excel 2007 allows hiding just an intermediate level. | Pivot saved as static data. |
| Workbook contains cells with data outside 256 x 65,536. | Excel 2000–2003 grid size is 256 x 65,536. Excel 2007 grid size is 18,278 x 1,048,576. | Data outside the the Excel 2000–2003 grid size is truncated. |
| Cell with more than 3 conditional formats | Excel 2000–2003 allows 3 conditions per cell. Excel 2007 allows 20 conditions per cell. | Conditions exceeding the Excel 2000–2003 limit are not displayed. |
| Cell with a data bar, color scale, or icon set condition type. | Excel 2000–2003 has no data bar, color scale, or icon set conditions. Excel 2007 has these conditions. | Unsupported conditions are not displayed. |
| Cell with a condition where StopIfTrue=False | Excel 2000–2003 always stops after a condition is true. Excel 2007 does not stop when StopIfTrue = False. | Stop after first true condition. |
| Cell with a conditional expression that references another sheet | Excel 2000–2003 does not allow cross-sheet cell references in conditional expressions. Excel 2007 allows this. | Condition is not evaluated. |
| Cell with a Top10 or AboveAverage rule where CalcFor =! AllValues | Excel 2000–2003 has no option to perform multiple calculations per Pivot “block.” Excel 2007 offers these options. | Condition is evaluated as if CalcFor = AllValues. |
| Workbook contains more than 4050 unique cell formats. Note: This check looks at the whole workbook, not just the formats used in the 256 x 65,536 range. | Excel 2000–2003 allows up to 4050 unique cell formats/styles. Excel 2007 allows up to 64k unique cell formats/styles. | Unique formats exceeding the Excel 2000–2003 limit are not persisted. |
| List contains a Total Row with a custom formula. | Excel 2000–2003 Total Rows must contain one of a list of predefined functions. Excel 2007 Total Rows allow user-defined formulas. | List saved as static data. |
| PivotTable field contains more than 32,500 unique items. | Excel 2000–2003 allows up to 32,500 unique items in a Pivot field. Excel 2007 increases this limit to 1,048,576. | Pivot saved as static data. |
| PivotTable item has string length greater than 255 characters. | Excel 2000–2003 allows item string length (MDX name in OLAP) up to 255 characters. Excel 2007 increases this limit to 32,767. | Pivot saved as static data. |
| Refedit contains more than 255 characters. | Excel 2000–2003 refedits allow up to 255 characters. Excel 2007 refedits allow between 2k and 8k characters. | In some cases, refedit works but user cannot see whole formula. In other cases, the feature does not work. |
| Cell with an array formula that references an entire column | Excel 2000–2003 does not allow column references (returns #NUM). Excel 2007 allows column references. | Formulas evaluate to #NUM. |
| Sort state with more than 3 sort levels | Excel 2000–2003 only supports 3 sort levels. Excel 2007 supports 64 sort levels. | Sort state will be lost. |
| User has a custom list sort. | Excel 2000–2003 only supports one custom list filter on the first column only. Excel 2007 supports many custom list sorts on any column. | Sort state will be lost. |
| User has a sort state that uses formatting. | Excel 2000–2003 only allows sorting on values. Excel 2007 also allows sorting on cell background color, cell foreground color, and cell icons. | Sort state will be lost. |
| User has a dynamic filter applied. | Excel 2000–2003 only supports value filters. Excel 2007 supports dynamic filters for items such as “today” and “last month.” | Filters will not be viewable, but the filtered rows will remain hidden. |
| User has a filter that filters by formatting. | Excel 2000–2003 only supports value filters. Excel 2007 supports filtering by cell background color, cell foreground color, and cell icon. | Filters will not be viewable, but the filtered rows will remain hidden. |
| User selects multiple items from the autofilter listview. | Excel 2000–2003 only supports filtering by 2 conditions. Excel 2007 allows the user to check multiple items from a list view control, which creates multiple sort conditions. | Filters will not be viewable, but the filtered rows will remain hidden. |