| Issue |
Solution |
| This workbook contains data in cells outside of the row and column limit of the selected file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will return a #REF! error. |
What it means In Excel 2010 and Excel 2007, the worksheet size is 16,384 columns by 1,048,576 rows, but the worksheet size of Excel 97-2003 is only 256 columns by 65,536 rows. Data in cells outside of this column and row limit is lost in Excel 97-2003.
What to do In the Compatibility Checker, click Find to locate the cells and ranges that fall outside the row and column limits, select those rows and columns, and then place them inside the column and row limits of the worksheet or on another worksheet by using the Cut and Paste commands.
|
| This workbook contains Scenarios with references to cells outside of the row and column limits of the selected file format. These Scenarios will not be saved in the selected file format. |
What it means A scenario in the worksheet refers to a cell outside the column and row limit of Excel 97-2003 (256 columns by 65,536 rows) and is no longer available when you continue saving the workbook to file format of the earlier version of Excel.
What to do In the Scenario Manager, look for the scenario that contains a reference that falls outside the row and column limit of the earlier version of Excel, and then change the reference to a location within that limit.
On the Data tab, in the Data Tools group, click What If Analysis, and then click Scenario Manager. In the Scenarios box, locate the scenario that causes the compatibility issue, and then edit its reference.
|
| This workbook contains dates in a calendar format that is not supported by the selected file format. These dates will be displayed as Gregorian dates. |
What it means In Excel 2010 and Excel 2007, you can create custom international calendar formats, such as Hebrew Lunar, Japanese Lunar, Chinese Lunar, Saka, Zodiac Chinese, Zodiac Korean, Rokuyou Lunar, and Korean Lunar. However, these calendar formats are not supported in Excel 97-2003.
What to do To avoid loss of functionality, you should change the calendar format to a language (or locale) that is supported in Excel 97-2003.
|
| This workbook contains dates in a calendar format that is not supported by the selected file format. These dates must be edited by using the Gregorian calendar. |
What it means In Excel 2010 and Excel 2007, you can apply a non-Western calendar type, such as Thai Buddhist or Arabic Hijri. In Excel 97-2003, these calendar types can only be edited in Gregorian.
What to do To avoid loss of functionality, you should change the calendar format to a language (or locale) that is supported in Excel 97-2003.
|
| This workbook contains more cells with data than are supported in earlier versions of Excel. Earlier versions of Excel will not be able to open this workbook. |
What it means In Excel 2010 and Excel 2007, the total number of available cell blocks (CLBs) is limited by available memory. In Excel 97-2003, the total number of available CLBs is limited to 64,000 CLBs in an instance of Excel.
A CLB includes 16 worksheet rows. If all rows in a worksheet contain data, you would have 4096 CLBs in that worksheet, and you could have only 16 such worksheets in a single instance of Excel (regardless of how many workbooks you have open in Excel).
What to do To make sure that the workbook does not exceed the 64,000 CLB limit and that it can be opened in Excel 97-2003, you should work in Compatibility Mode in Excel 2010 after you save the workbook to Excel 97-2003 file format. In Compatibility Mode, Excel keeps track of the CLBs in the active workbook.
|
| One or more cells in this workbook contain a sparkline. Sparklines will not be saved. |
What it means In Excel 2007 and Excel 97-2003, sparklines that show trends in a series of values are not displayed on the worksheet.
However, all sparklines remain available in the workbook and are applied when the workbook is opened again in Excel 2010.
What to do In the Compatibility Checker, click Find to locate cells that contain sparklines, and then make the necessary changes. For example, you could apply conditional formatting instead of or in addition to the sparklines that won't be displayed in the earlier version of Excel.
|
| This file originally contained features which were not recognized by this version of Excel. These features will not be saved. |
What it means Features that were used in this workbook are not available in versions of Excel prior to Excel 2007 (Excel 97-2003), and they will be lost.
What to do If you know which features might be causing this issue, remove or replace them if possible, and then save the file in the file format that you want.
|
| This file originally contained features which were not recognized by this version of Excel. These features are not preserved when saving an OpenXML file to the XLSB file format, or vice versa. |
What it means Features that were used in this workbook will not be available in Excel 2007 when you save an OpenXML file to an Excel Binary Workbook (.xlsb), or vice versa. When you continue saving the file, the features will be lost.
What to do If you know which features might be causing this issue, remove or replace them if possible, and then save the file in the file format that you want.
|
