Some formulas contain references to tables that are not supported in the selected file format. What to do In the Compatibility Checker, click Find to locate PivotTable report fields that contain conditional formatting rules, and then apply conditional formatting rules that are available in the earlier versions of Excel. Some formulas contain arrays with more elements than are supported by the selected file format. Feel free to reply to this thread if you have any additional issues on this topic. Converting a workbook from an earlier version of Excel to the Excel 2007 and later file format can cause problems when full row or column references are used in that workbook, and data that was not meant to be included in the references has been entered in cells that are beyond the row and column limit of the earlier version of Excel.
Step 2: Click the File tab at the top-left corner of the window. Full row and full column references automatically take into account the cells in the larger grid size of Excel 2007 and later. What to do To avoid losing specific font formats that you want to keep available in Excel 97-2003, you can remove some font formats that are not as important to keep. Want to learn more about Excel? You may want to quickly look through the document to confirm that there are no layout changes you need to fix. Earlier versions of Excel do not recognize this option and will stop after the first true condition. What it means In Excel 97-2003, you will not see conditional formatting types, such as data bars, color scales, icon sets, top or bottom ranked values, above or below average values, unique or duplicate values, and table column comparison to determine which cells to format.
What to do Use PivotTable filters instead of slicers to filter the data. PivotTable style formatting cannot be displayed in earlier versions of Excel. The version with a check mark next to it is the Compatibility Mode the document is currently using. In Excel 97-2007, text that overflows the boundaries of an object will not be visible. Only the most current was available. Unsupported features have either been replaced by new features and functionality, or they have been removed because they were rarely used. Also, the AppData folder and everything under it is marked as Hidden by default, so you might not be able to see it if you try to navigate the folders.
However, all conditional formatting rules remain available in the workbook and are applied when the workbook is opened again in Excel 2007 and later, unless the rules were edited in Excel 97-2003. I dont know why the settings keep reverting back to an. What it means In Excel 97-2003, conditional formatting that displays a specific icon set arrangement is not supported and the icon set arrangement is not displayed on the worksheet. These page headers and footers cannot be displayed in earlier versions of Excel. Exit Compatibility mode If you no longer want to work in Compatibility Mode, you can convert the workbook to the current file format. My version of 2007 seems to be working ok.
Slicers will not be saved. I am using Excel 2010 and it keeps opening in Compatibility mode. What it means Slicers are not supported in Excel 97-2007 and cannot be shown. Microsoft excel may be able to save the file by removing or repairing some features. These formats will be converted to the closest format available.
What to do In the Compatibility Checker, click Find to locate the cells that contain formulas with structured references to tables so that you can change them to the cell references that you want to use. What it means A scenario in the worksheet refers to a cell outside the column and row limit of Excel 97-2003 65,536 rows by 256 columns , and is no longer available when you continue saving the workbook to file format of the earlier version of Excel. What it means In Excel 97-2007, conditional formatting that contains a data bar rule that uses a solid color fill or border or left to right and right to left bar direction settings for data bars is not displayed on the worksheet. The special effects will be removed. What to do Save the workbook to the Excel 97-2003 file format, and then work with that workbook in Compatibility Mode.
This only seemed to work on the workbooks I had open. Significant loss of functionality Solution Any effects on this object will be removed. You cannot use the mouse to change the rotation of a 3-D chart. What to do In the Compatibility Checker, click Find to locate the data that has been filtered, and then you can clear the filter to unhide the rows that are hidden. Rows that are hidden by the filter will remain hidden, but the filter itself will not display correctly in earlier versions of Excel. What it means Beginning with Excel 2010, you can use more than 32,000 data points per series in 2-D charts and more than 4,000 data points per series in 3-D charts. However, all sort state information remains available in the workbook and is applied when the workbook is opened again in Excel 2007 and later, unless the sort state information is edited in Excel 97-2003.
You can then specify that the Compatibility Checker runs automatically every time that you save that workbook. The above worked perfectly for me to open in xlsx. This workbook contains Scenarios with references to cells outside of the row and column limits of the selected file format. The file format of compatibility mode In Compatibility Mode, any new or enhanced Excel features are not available, which prevents loss of data and fidelity when the workbook is opened in an earlier version of Excel. The new software, Say Excel 2013, can open a document that was created in Excel 2010 0r even 2007. What it means Beginning with Excel 2007, you can use 64,000 unique cell formats, but in Excel 97-2003, you can only use up to 4,000 unique cell formats. Rows that are hidden by the filter will remain hidden, but the filter itself will not display correctly in earlier versions of Excel.