Convert xlsx to xls

     
Excel for racingbananas.com 365 Excel 2021 Excel 2019 Excel năm 2016 Excel 2013 Excel 2010 Excel 2007 Excel Starter 2010 More...Less

After you have installed a new version of Excel, you may want khổng lồ know how you can continue to lớn work with workbooks that are created in an earlier version of Excel, how you can keep these workbooks accessible for users who vì not have the current version of Excel installed, và how the differences between the versions affect the way that you work.

Bạn đang xem: Convert xlsx to xls

For backward compatibility with earlier versions of Excel, such as Excel 97-2003, you can use one of two ways khổng lồ exchange workbooks between the different versions.

Work in Compatibility Mode You can mở cửa a workbook that was created in an earlier version of Excel and work in Compatibility Mode so that the workbook remains in a file format that can easily be opened again in the earlier version. Compatibility mode is not available for Excel 2007 workbooks.

Check a workbook for compatibility If you want to lớn work in the current tệp tin format but have to mô tả a workbook with people who use earlier versions of Excel, you can kiểm tra that the data is compatible with earlier versions of Excel. You can then make the necessary changes lớn avoid the loss of data or fidelity that might occur when that workbook is opened in an earlier version of Excel.

Work in compatibility mode

In Excel 2010 & later, when you xuất hiện a workbook that was created in Excel 97-2003, it is automatically opened in Compatibility Mode, & you see Compatibility Mode in square brackets next to lớn the tệp tin name in the Excel title bar.

The file format of compatibility mode

In Compatibility Mode, any new or enhanced Excel features are not available, which prevents loss of data & fidelity when the workbook is opened in an earlier version of Excel. Also, instead of using a current tệp tin format (.xlsx, .xlsb, .xlsm, .xltx, .xltm), the workbook is saved in Excel 97-2003 file format (.xls), a tệp tin format that can be opened by earlier versions of Excel.

Compatibility mode is automatic

Unlike other Office programs, such as Word, you cannot manually turn on Compatibility Mode in Excel, & you vị not have the option khổng lồ include any new features when you work in a workbook in Compatibility Mode.

Exit Compatibility mode

If you no longer want lớn work in Compatibility Mode, you can convert the workbook khổng lồ the current tệp tin format. For information, see Convert a workbook khổng lồ a new file format.

New features that are not racingbananas.comed in earlier versions of Excel

Not all new features are racingbananas.comed in earlier versions of Excel. When you work in Compatibility Mode or want lớn save aworkbook to the Excel 97-2003 (.xls) tệp tin format, the Compatibility Checker can help you identify issues that may cause a significant loss of functionality or a minor loss of fidelity in the earlier version of Excel. To avoid the loss of data or functionality in an earlier version of Excel, you can then make the necessary changes to lớn your current workbook.

When you save a workbook lớn an Excel 97-2003 file format, the Compatibility Checker runs automatically. However, to lớn verify that a workbook is compatible with your current version of Excel, you must run the Compatibility Checker manually the first time you save the workbook. You can then specify that the Compatibility Checker runs automatically every time that you save that workbook. For information about how to run the Compatibility Checker, see kiểm tra an Excel workbook for compatibility with earlier versions of Excel.

The Compatibility Checker lists the compatibility issues it finds, and provides a FindHelp button for many issues. You can then locate all occurrences of the issue, & get information about ways to resolve the issue. When run automatically, the Compatibility Checker also specifies the version of Excel in which a potential compatibility issue occurs.

*

Unracingbananas.comed worksheet features

Unracingbananas.comed worksheet features can cause the following compatibility issues, leading to a significant loss of functionality or a minor loss of fidelity.

Significant loss of functionality

Solution

This workbook has label information that will be lost or not visible if the tệp tin is saved as an earlier Excel format.

What it means If you save this workbook in .xls format, the labels will be permanently lost. If you save it in .xlsx format the labels will be preserved, but won’t display in Excel năm nhâm thìn or earlier versions.

What to vị to preserve the labels, avoid saving the workbook in .xls format. If you need people who can’t open .xlsx files to lớn be able to open the workbook, consider opening the workbook in Excel for the web & sending the tệp tin URL to them at an email address that is registered as a racingbananas.com Account. 

This workbook contains data in cells outside of the row & column limit of the selected tệp tin format. Data beyond 65,536 rows tall by 256 (IV) columns wide will not be saved. Formula references to lớn data in this region will return a #REF! error.

What it means Beginning with Excel 2007, the worksheet kích thước is 1,048,576 rows tall by16,384 columns wide, but Excel 97-2003 is only 65,536 rows tall by 256 columns wide. Data in cells outside of this column & row limit is lost in Excel 97-2003.

What to do In the Compatibility Checker, click Find to lớn locate the cells & ranges that fall outside the row and column limits, select those rows và columns, and then place them inside the column and row limits of the worksheet or on another worksheet by using the Cut & Paste commands.

*

This workbook contains Scenarios with references to lớn cells outside of the row & column limits of the selected tệp tin format. These Scenarios will not be saved in the selected tệp tin format.

What it means A scenario in the worksheet refers to lớn a cell outside the column and row limit of Excel 97-2003 (65,536 rows by 256 columns), và is no longer available when you continue saving the workbook to tệp tin format of the earlier version of Excel.

What to lớn do In the Scenario Manager, look for the scenario that contains a reference that falls outside the row và column limit of the earlier version of Excel, & then change the reference khổng lồ 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, & then edit its reference.

This workbook contains dates in a calendar format that is not racingbananas.comed by the selected tệp tin format. These dates will be displayed as Gregorian dates.

What it means Beginning with Excel 2007, you can create custom international calendar formats, such as Hebrew Lunar, Japanese Lunar, Chinese Lunar, Saka, Zodiac Chinese, Zodiac Korean, Rokuyou Lunar, & Korean Lunar. However, these calendar formats are not racingbananas.comed in Excel 97-2003.

What to lớn do to lớn avoid loss of functionality, you should change the calendar format lớn a language (or locale) that is racingbananas.comed in Excel 97-2003.

This workbook contains dates in a calendar format that is not racingbananas.comed by the selected tệp tin format. These dates must be edited by using the Gregorian calendar.

What it means Beginning with 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 lớn do to lớn avoid loss of functionality, you should change the calendar format khổng lồ a language (or locale) that is racingbananas.comed in Excel 97-2003.

This workbook contains more cells with data than are racingbananas.comed in earlier versions of Excel. Earlier versions of Excel will not be able to open this workbook.

What it means Beginning with 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 khổng lồ 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 mở cửa in Excel).

What lớn do lớn make sure that the workbook does not exceed the 64,000 câu lạc bộ limit và that it can be opened in Excel 97-2003, you should work in Compatibility Mode after you save the workbook lớn Excel 97-2003 tệp tin 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 97-2007, sparklines that show trends in a series of values are not displayed on the worksheet.

However, all sparklines remain available in the workbook & are applied when the workbook is opened again in Excel 2010 or later.

What khổng lồ 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.

Minor loss of fidelity

Solution

Earlier versions of Excel vì chưng not racingbananas.com màu sắc formatting in header và footer text. The màu sắc formatting information will be displayed as plain text in earlier versions of Excel.

What it means Beginning with Excel 2007, you can apply màu sắc formatting lớn header and footer text. You cannot use color formatting in headers & footers in Excel 97-2003.

What to lớn do In the Compatibility Checker, click Fix if you want to remove the màu sắc formatting.

*

This workbook contains worksheets that have even page or first page headers and footers. These page headers & footers cannot be displayed in earlier versions of Excel.

What it means Beginning with Excel 2007, you have the option khổng lồ display different header & footer text on even pages or on the first page. In Excel 97-2003, even page or first page headers and footers cannot be displayed, but they remain available for display when you open the workbook in Excel 2007 and later again.

What to lớn do If you frequently save a workbook to Excel 97-2003 file format, it is best not lớn specify even or first page headers or footers for that workbook.

Some cells or styles in this workbook contain formatting that is not racingbananas.comed by the selected tệp tin format. These formats will be converted lớn the closest format available.

What it means Beginning with Excel 2007, different cell formatting or cell style options, such as special effects & shadows, are available. These options are not available in Excel 97-2003.

What khổng lồ do When you continue saving the workbook, Excel applies the closest available format, which can be identical to lớn another format you applied to lớn something else. Khổng lồ avoid duplication of formats, you can change or remove the cell formatting and cell styles that are not racingbananas.comed before you save the workbook lớn Excel 97-2003 tệp tin format.

This workbook contains more chất lượng cell formats than are racingbananas.comed by the selected tệp tin format. Some cell formats will not be saved.

What it means Beginning with Excel 2007, you can use 64,000 quality cell formats, but in Excel 97-2003, you can only use up lớn 4,000 chất lượng cell formats. Chất lượng cell formats include any specific combination of formatting that is applied in a workbook.

What to lớn do lớn avoid losing specific cell formats that you want khổng lồ keep available in Excel 97-2003, you can remove some cell formats that are not as important khổng lồ keep.

This workbook contains more chất lượng font formats than are racingbananas.comed in the selected tệp tin format. Some fonts formats will not be saved.

What it means Beginning with Excel 2007, 1,024 global fonts types are available, & you can use up to lớn 512 of them per workbook. Excel 97-2003 racingbananas.coms less quality font formats.

What to do khổng lồ avoid losing specific font formats that you want khổng lồ keep available in Excel 97-2003, you can remove some font formats that are not as important khổng lồ keep.

For more information about how to lớn resolve one or more of these compatibility issues, see the following articles:

Unracingbananas.comed Excel table features

Unracingbananas.comedExcel table features can cause the following compatibility issues, leading khổng lồ a minor loss of fidelity.

Minor loss of fidelity

Solution

The table contains a custom formula or text in the total row. In earlier versions of Excel, the data is displayed without a table.

What it means Although the formulas và text remain intact in Excel 97-2003, the range will no longer be in table format.

What khổng lồ do In the Compatibility Checker, click Find to locate the table that contains a custom formula or text, remove that formula or text from the total row, và then use only formulas that are available in the total row.

A table in this workbook does not display a header row. In earlier versions of Excel, the data is displayed without a table unless the My các mục has headers check box is selected (Data > List > Create List).

What it means In Excel 97-2003, a table cannot be displayed without a header row.

What khổng lồ do In the Compatibility Checker, click Find khổng lồ locate the table that is displayed without a header row, & then display a header row.

A table style is applied khổng lồ a table in this workbook. Table style formatting cannot be displayed in earlier versions of Excel.

What it means In Excel 97-2003, theme-based table styles are not available & cannot be displayed.

What to do In the Compatibility Checker, click Find khổng lồ locate the table that has a table style applied, remove that table style, & then format the table manually.

A table in this workbook is connected to an external data source. Table functionality will be lost, but the data remains connected. If table rows are hidden by a filter, they remain hidden in an earlier version of Excel.

What it means Table functionality is lost in Excel 97-2003.

What khổng lồ do In the Compatibility Checker, click Find to lớn locate the table that is connected khổng lồ an external data source, & then disconnect the table from the external data source. In Excel 97-2003, you can then connect the data khổng lồ the external data source again.

A table in this workbook has a read-only connection to lớn a Windows SharePoint Services List. Table functionality will be lost, as well as the ability to lớn refresh or edit the connection. If table rows are hidden by a filter, they remain hidden in an earlier version of Excel.

What it means Table functionality is lost in Excel 97-2003.

What to lớn do In the Compatibility Checker, click Find lớn locate the table that has a read-only connection to lớn a racingbananas.com SharePoint Foundation List, and then disconnect the table from the SharePoint List. In Excel 2003, you can then import the SharePoint list as a read/write list.

You can also create a read/write danh sách in an Excel 2003 workbook, and then work on this workbook in Compatibility Mode in Excel 2010, which keeps it in Excel 97-2003 tệp tin format.

Alternative text is applied lớn a table in this workbook. Alternative text on tables will be removed in versions prior to lớn Excel 2010.

What it means Alternative text is not available in Excel 97-2007, & cannot be displayed in these earlier versions of Excel.

What lớn do In the Compatibility Checker, click Find khổng lồ locate the Excel table that contains alternative text. To lớn display the alternative text in the earlier version of Excel, you can copy it into a blank cell on the worksheet, or you could insert a bình luận that contains the text.

Right-click anywhere in the table, click Table, & then click Alternative Text. In the Description box, select the alternative text, & then press CTRL+C to copy it.

For more information about how lớn resolve one or more of these compatibility issues, see the following article:

Unracingbananas.comed PivotTable features

Unracingbananas.comed PivotTable features can cause the following compatibility issues, leading khổng lồ a significant loss of functionality or a minor loss of fidelity.

Significant loss of functionality

Solution

A PivotTable in this workbook exceeds former limits & will be lost if it is saved khổng lồ earlier tệp tin formats. Only PivotTables that are created in Compatibility Mode will work in earlier versions of Excel.

What it means Beginning with Excel 2007, a PivotTable report racingbananas.coms 1,048,576 unique items per field, but in Excel 97-2003, only 32,500 items per field are racingbananas.comed.

What khổng lồ do In the Compatibility Checker, click Find to lớn locate the PivotTable report that exceeds the former limits. Save the workbook to Excel 97-2003 format, and then re-create this PivotTable report in Compatibility Mode.

A PivotTable in this workbook contains conditional formatting rules that are applied to lớn cells in collapsed rows or columns. To avoid losing these rules in earlier versions of Excel, expand those rows or columns.

What it means Conditional formatting rules that are applied to lớn cells in collapsed rows or columns will be lost in Excel 97-2003.

What to lớn do In the Compatibility Checker, click Find khổng lồ locate the collapsed rows or columns that contain conditional formatting rules, and then expand those rows or columns before you save the workbook in an earlier Excel tệp tin format.

This workbook contains named sets which are not associated with a PivotTable. These named sets will not be saved.

What it means Named sets that are not associated with a PivotTable will be removed in Excel 97-2007.

What to lớn do to avoid this issue, make sure that you create a PivotTable by using a connection.

A PivotTable in this workbook has what-if analysis turned on. Any unpublished what-if changes will be lost in earlier versions of Excel.

What it means What-if analysis changes that are not published to the hệ thống are not displayed in the earlier version of Excel.

What to do Make sure that you publish the what-if analysis changes before you mở cửa the workbook in an earlier version of Excel (PivotTable Tools, Options tab, Tools group, What-If Analysis button).

A PivotTable in this workbook contains a data axis upon which the same measure appears more than once. This PivotTable will not be saved.

What it means Beginning with Excel 2010, you can duplicate a measure in a PivotTable that is connected to lớn an Online Analytical Processing (OLAP) data source. The PivotTable cannot be displayed in Excel 97-2007.

What to do In the Compatibility Checker, click Find to locate the PivotTable report that contains a data axis upon which more than one of the same measure appears, & then remove any duplicate measures so that only one measure remains.

A PivotTable or data connection in this workbook contains vps settings which bởi not exist in earlier versions of Excel. Some PivotTable or data connection server settings will not be saved.

What it means Some PivotTable or data connection hệ thống settings that are not available in Excel 97-2007 will be lost.

What to do Verify that the vps settings you use are compatible with earlier versions of Excel & then make the necessary changes (PivotTable Tools, Options tab, Data group, Change Data Source button, Connection Properties command).

A PivotTable in this workbook contains data represented using the "Show Values As" feature. These custom outputs will not be saved, & will be replaced by the original values from the data source.

What it means The Show Values As feature is not racingbananas.comed in Excel 97-2007 & custom value data you entered (such as % of Grand Total, % of Column Total, or Running Total In) cannot be displayed.

What lớn do In the Compatibility Checker, click Find to locate the PivotTables that contain custom value outputs, và then remove those outputs (PivotTable Tools, Options tab, Calculations group, Show Values As button).

Alternative text is applied lớn a PivotTable in this workbook. Alternative text on PivotTables will be removed in versions prior to lớn Excel 2010.

What it means Alternative text is not available in Excel 97-2007, và cannot be displayed in these earlier versions of Excel.

What to do In the Compatibility Checker, click Find to locate the PivotTable that contains alternative text. To lớn display the alternative text in the earlier version of Excel, you can copy it into a blank cell on the worksheet, or you could insert a bình luận that contains the text.

Right-click anywhere in the PivotTable, click PivotTable Options. On the Alt Text tab, in the Description box, select the alternative text, và then press CTRL+C to copy it.

Minor loss of fidelity

Solution

A PivotTable style is applied to a PivotTable in this workbook. PivotTable style formatting cannot be displayed in earlier versions of Excel.

What it means Theme-based PivotTable styles are not available in Excel 97-2003 và cannot be displayed.

What to do In the Compatibility Checker, click Find khổng lồ locate the PivotTable report that has a PivotTable style applied, remove that PivotTable style, and then manually apply PivotTable formatting that is racingbananas.comed in the earlier versions of Excel.

A PivotTable in this workbook will not work in versions prior to Excel 2007. Only PivotTables that are created in Compatibility Mode will work in earlier versions of Excel.

What it means A PivotTable report you create in Excel 2007 and later cannot be refreshed in Excel 97-2003.

What to do In the Compatibility Checker, click Find to locate the PivotTable report that is created in the current tệp tin format. Save the workbook khổng lồ Excel 97-2003 format, and then re-create this PivotTable report in Compatibility Mode so that you can open it in Excel 97-2003 without loss of functionality.

A PivotTable in this workbook has fields in compact form. In earlier versions of Excel, this layout will be changed to tabular form.

What it means Compact size (alone or in combination with tabular and outline form) to lớn keep related data from spreading horizontally off of the screen and to help minimize scrolling is not available in Excel 97-2003, & fields will be displayed in tabular form.

What to do In the Compatibility Checker, click Find to lớn locate the PivotTable report that has fields in a compact form, & then change that format khổng lồ outline form or tabular khung as needed by clearing the Merge and center cells with labels check box (PivotTable Tools, Options tab, PivotTable group, Options command, Layout và Format tab).

A PivotChart in this workbook has specific field buttons enabled or disabled. All field buttons will be saved as enabled.

What it means Field buttons that are not shown on a PivotChart will be saved as enabled when mở cửa and save the workbook in an earlier version of Excel.

What to lớn do When you reopen a workbook after you save it to lớn a file format of an earlier version of Excel, you may have to enable and disable field buttons to lớn display the ones that you want (PivotChart Tools, Analyze tab, Show/Hide group, Field Buttons button).

This workbook contains Slicers that can be used khổng lồ filter PivotTables and CUBE functions within the workbook. Slicers will not work in earlier versions of Excel.

What it means Slicers were not introduced until Excel 2010.

What to do In the earlier version of Excel, you can use PivotTable filters khổng lồ filter data.

This workbook contains Slicers that can be used khổng lồ filter PivotTables and CUBE functions within the workbook. Slicers will not be saved. Formulas that reference Slicers will return a #NAME? error.

What it means Slicers are not racingbananas.comed in Excel 97-2007 and cannot be shown.

When you refresh the connection or update a PivotTable, the filters that were applied by the slicers are no longer displayed, & the slicers will be lost.

Refreshing connections that have OLAP Functions which reference slicers will return #NAME? errors instead of the expected results.

What to do Use PivotTable filters instead of slicers to filter the data.

A slicer style exists in this workbook, and is not racingbananas.comed in earlier versions of Excel. This slicer style will not be saved.

What it means A custom slicer style will be lost when the workbook is saved to the tệp tin format of an earlier version of Excel.

What to do Change the custom slicer style lớn a built-in slicer style before you save the workbook to an earlier Excel file format (Slicer Tools, Options tab, Slicer Styles gallery).

A PivotTable in this workbook contains one or more fields that contain repeated labels. If the PivotTable is refreshed, these labels will be lost.

What it means Repeated labels are not racingbananas.comed in Excel 97-2007, và the labels will be lost when you refresh the PivotTable report in the earlier version of Excel.

What to lớn do In the Compatibility Checker, click Find lớn locate the PivotTable that contains repeated labels, and then stop repeating labels (PivotTable Tools, Design tab, Layout group, Report Layout button, Do Not Repeat thắng lợi Labels command).

For more information about how to lớn resolve one or more of these compatibility issues, see the following article:

Unracingbananas.comed sorting & filtering features

Unracingbananas.comed sorting và filtering features can cause the following compatibility issues, leading to lớn a minor loss of fidelity.

Minor loss of fidelity

Solution

A worksheet in this workbook contains a sort state with more than three sort conditions. This information will be lost in earlier versions of Excel.

What it means Beginning with Excel 2007, you can apply sort states with up khổng lồ sixty-four sort conditions to lớn sort data by, but Excel 97-2003 racingbananas.coms sort states with up to lớn three conditions only. To avoid losing sort state information in Excel 97-2003, you may want to change the sort state to one that uses no more than three conditions. In Excel 97-2003, you can also sort the data manually.

However, all sort state information remains available in the workbook và is applied when the workbook is opened again in Excel 2007 & later, unless the sort state information is edited in Excel 97-2003.

What lớn do In the Compatibility Checker, click Find to lớn locate the data that has been sorted with more than three conditions, và then change the sort state by using only three or less conditions.

A worksheet in this workbook contains a sort state that uses a sort condition with a custom list. This information will be lost in earlier versions of Excel.

What it means Beginning with Excel 2007, you can sort by a custom list. Khổng lồ get similar sorting results in Excel 97-2003, you can group the data that you want to sort, và then sort the data manually.

However, all sort state information remains available in the workbook & is applied when the workbook is opened again in Excel 2007 & later, unless the sort state information is edited in Excel 97-2003.

What to lớn do In the Compatibility Checker, click Find lớn locate the data that has been sorted by a custom list, and then change the sort state so that it no longer contains a custom list.

A worksheet in this workbook contains a sort state that uses a sort condition that specifies formatting information. This information will be lost in earlier versions of Excel.

Xem thêm: Xem Phim Yêu Không Kiểm Soát Full 20/20 Vietsub + Thuyết Minh

What it means Beginning with Excel 2007, you can sort data by a specific format, such as cell color, phông color, or icon sets. In Excel 97-2003, you can sort only text.

However, all sort state information remains available in the workbook & is applied when the workbook is opened again in Excel 2007 và later, unless the sort state information is edited in Excel 97-2003.

What khổng lồ do In the Compatibility Checker, click Find to locate the data that has been sorted by a specific format, and then change the sort state without specifying formatting information.

Minor loss of fidelity

Solution

Some data in this workbook is filtered in a way that is not racingbananas.comed in earlier versions of Excel. 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 2007, you can apply filters that are not racingbananas.comed in Excel 97-2003. To lớn avoid losing filter functionality, you may want to lớn clear the filter before you save the workbook in an earlier Excel file format. In Excel 97-2003, you can then filter the data manually.

However, all filter state information remains available in the workbook & is applied when the workbook is opened again in Excel 2007 & later, unless the filter state information is edited in Excel 97-2003.

What lớn do In the Compatibility Checker, click Find lớn locate the data that has been filtered, và then you can clear the filter lớn unhide the rows that are hidden. On the Home tab, in the Editing group, click Sort và Filter, và then click Clear to clear the filter.

Some data in this workbook is filtered by a cell color. 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 2007, you can filter by a cell color, font color, or icon set — these methods are not racingbananas.comed in Excel 97-2003. To avoid losing filter functionality, you may want to lớn clear the filter before you save the workbook in an earlier Excel tệp tin format. In Excel 97-2003, you can then filter the data manually.

However, all filter state information remains available in the workbook & is applied when the workbook is opened again in Excel 2007 và later, unless the filter state information is edited in Excel 97-2003.

What lớn do In the Compatibility Checker, click Find to lớn locate the data that has been filtered, & then you can clear the filter to unhide the rows that are hidden. On the Home tab, in the Editing group, click Sort & Filter, và then click Clear khổng lồ clear the filter.

Some data in this workbook is filtered by a phông color. 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 2007, you can filter by a cell color, fonts color, or icon set — these methods are not racingbananas.comed in Excel 97-2003. To lớn avoid losing filter functionality, you may want khổng lồ clear the filter before you save the workbook in an earlier Excel tệp tin format. In Excel 97-2003, you can then filter the data manually.

However, all filter state information remains available in the workbook and is applied when the workbook is opened again in Excel 2007 and later, unless the filter state information is edited in Excel 97-2003.

What to lớn do In the Compatibility Checker, click Find khổng lồ locate the data that has been filtered, & then you can clear the filter to lớn unhide the rows that are hidden. On the Home tab, in the Editing group, click Sort và Filter, & then click Clear to clear the filter.

Some data in this workbook is filtered by a cell icon. 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 2007, you can filter by a cell color, phông color, or icon set — these methods are not racingbananas.comed in Excel 97-2003. To lớn avoid losing filter functionality, you may want lớn clear the filter before you save the workbook in an earlier Excel tệp tin format. In Excel 97-2003, you can then filter the data manually.

However, all filter state information remains available in the workbook & is applied when the workbook is opened again in Excel 2007 and later, unless the filter state information is edited in Excel 97-2003.

What to lớn do In the Compatibility Checker, click Find lớn locate the data that has been filtered, and then you can clear the filter lớn unhide the rows that are hidden. On the Home tab, in the Editing group, click Sort & Filter, & then click Clear to lớn clear the filter.

Some data in this workbook is filtered by more than two criteria. 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 2007, you can filter data by more than two criteria. Khổng lồ avoid losing filter functionality, you may want to lớn clear the filter before you save the workbook in an earlier Excel tệp tin format. In Excel 97-2003, you can then filter the data manually.

However, all filter state information remains available in the workbook & is applied when the workbook is opened again in Excel 2007 và later, unless the filter state information is edited in Excel 97-2003.

What to do In the Compatibility Checker, click Find to lớn locate the data that has been filtered, và then you can clear the filter to unhide the rows that are hidden. On the Home tab, in the Editing group, click Sort & Filter, & then click Clear to clear the filter.

Some data in this workbook is filtered by a grouped hierarchy of dates, resulting in more than two criteria. 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 2007, you can filter dates by a grouped hierarchy. Because this is not racingbananas.comed in Excel 97-2003, you may want to ungroup the hierarchy of dates. Khổng lồ avoid losing filter functionality, you may want khổng lồ clear the filter before you save the workbook in an earlier Excel tệp tin format.

However, all filter state information remains available in the workbook & is applied when the workbook is opened again in Excel 2007 và later, unless the filter state information is edited in Excel 97-2003.

What khổng lồ do In the Compatibility Checker, click Find lớn locate the data that has been filtered, và then you can clear the filter to unhide the rows that are hidden. On the Home tab, in the Editing group, click Sort và Filter, & then click Clear to clear the filter.

Data grouping can also be turned off on from File > Options > Advanced > Display options for this workbook > Uncheck the Group dates in the AutoFilter menu option.

If you"re using Excel 2007, press the Office button , then Excel Options.

Unracingbananas.comed formula features

Unracingbananas.comed formula features can cause the following compatibility issues, leading to a significant loss of functionality or a minor loss of fidelity.

Significant loss of functionality

Solution

Some worksheets contain more array formulas that refer to lớn other worksheets than are racingbananas.comed by the selected file format. Some of these array formulas will not be saved và will be converted to lớn #VALUE! errors.

What it means Beginning with Excel 2007, workbook arrays that refer to other worksheets are limited only by available memory, but in Excel 97-2003, worksheets can only contain up lớn 65,472 workbook arrays that refer lớn other worksheets. Workbook arrays beyond the maximum limit will be converted to and display #VALUE! errors.

What lớn do In the Compatibility Checker, click Find lớn locate cells that contain array formulas that refer to lớn another worksheet, & then make the necessary changes lớn avoid #VALUE! errors.

Some formulas contain more values, references, and/or names than are racingbananas.comed by the selected tệp tin format. These formulas will not be saved and will be converted lớn #VALUE! Errors.

What it means Beginning with Excel 2007, the maximum length of formula contents is 8,192 characters, và the maximum internal formula length is 16,384 bytes. In Excel 97-2003, the maximum length of formula contents is 1,024 characters, và the maximum internal formula length is 1,800 bytes. When the combination of formula arguments (including values, references, and/or names) exceeds the maximum limits of Excel 97-2003, the formulas will result in #VALUE! errors when you save the workbook khổng lồ an earlier Excel file format.

What to do In the Compatibility Checker, click Find to lớn locate the cells that contain formulas that exceed the maximum formula length limits of Excel 97-2003, và then make the necessary changes to avoid #VALUE! errors.

Some formulas have more levels of nesting than are racingbananas.comed by the selected tệp tin format. Formulas with more than seven levels of nesting will not be saved và will be converted khổng lồ #VALUE! errors.

What it means Beginning with Excel 2007, a formula can contain up to 64 levels of nesting, but in Excel 97-2003, the maximum levels of nesting is only 7.

What khổng lồ do In the Compatibility Checker, click Find khổng lồ locate the cells that contain formulas with more than 7 levels of nesting, and then make the necessary changes lớn avoid #VALUE! errors.

Some formulas contain functions that have more arguments than are racingbananas.comed by the selected tệp tin format. Formulas that have more than 30 arguments per function will not be saved & will be converted to lớn #VALUE! errors.

What it means Beginning with Excel 2007, a formula can contain up khổng lồ 255 arguments, but in Excel 97-2003, the maximum limit of arguments in a formula is only 30.

What khổng lồ do In the Compatibility Checker, click Find lớn locate the cells that contain formulas with more than 30 arguments, & then make the necessary changes to avoid #VALUE! errors.

Some formulas use more operands than are allowed by the selected file format. These formulas will not be saved and will be converted lớn #VALUE! errors.

What it means Beginning with Excel 2007, the maximum number of operands that can be used in formulas is 1,024, but in Excel 97-2003, the maximum limit of operands in formulas is only 40.

What khổng lồ do In the Compatibility Checker, click Find lớn locate the cells that contain formulas with more than 40 operands, và then make the necessary changes khổng lồ avoid #VALUE! errors.

Some formulas contain functions with more arguments than are racingbananas.comed by the selected tệp tin format. Formulas with more than 29 arguments lớn a function will not be saved & will be converted to lớn #VALUE! errors.

What it means Beginning with Excel 2007, a User-Defined Function (UDF) that you create by using Visual Basic for Applications (VBA) can contain up khổng lồ 60 arguments, but in Excel 97-2003, the number of arguments in UDFs are limited by VBA to only 29.

What khổng lồ do In the Compatibility Checker, click Find to locate the cells that contain functions that use more than 29 arguments, and then make the necessary changes to avoid #VALUE! errors. You may have to use VBA code to change user-defined functions.

One or more functions in this workbook are not available in earlier versions of Excel. When recalculated in earlier versions, these functions will return a #NAME? error instead of their current results.

What it means Beginning with Excel 2007, new và renamed functions were added. Because these functions are not available in Excel 97-2003, they will return a #NAME? error instead of the expected results when the workbook is opened in the earlier version of Excel..

In some cases, the prefix _xlfn is added lớn the formula, for example, =_xlfn.IFERROR (1,2).

What to lớn do In the Compatibility Checker, click Find to locate the cells that contain functions that are not available in earlier versions of Excel, và then make the necessary changes lớn avoid #NAME? errors.

Compatibility functions are available for all functions that have been renamed. To lớn avoid errors, you can use those functions instead.

New functions can be replaced with appropriate functions that are available in the earlier versions of Excel. You can also remove formulas that use new functions by replacing them with the formula results.

Some formulas contain references to lớn tables that are not racingbananas.comed in the selected tệp tin format. These references will be converted to lớn cell references.

What it means Beginning with Excel 2007, you can use structured references to make it much easier and more intuitive lớn work with table data when you are using formulas that reference a table, either portions of a table, or the entire table. This feature is not racingbananas.comed in Excel 97-2003, và structured references will be converted khổng lồ cell references.

What to lớn do In the Compatibility Checker, click Find khổng lồ locate the cells that contain formulas with structured references to lớn tables so that you can change them lớn the cell references that you want lớn use.

Some formulas contain references to tables in other workbooks that are not currently mở cửa in this instance of Excel. These references will be converted khổng lồ #REF on save to Excel 97-2003 format because they cannot be converted to lớn sheet references.

What it means Beginning with Excel 2007, you can use structured references lớn make it much easier and more intuitive to lớn work with table data when you are using formulas that reference a table, either portions of a table, or the entire table. This feature is not racingbananas.comed in Excel 97-2003, & structured references will be converted lớn cell references. However, if the structured references point lớn tables in other workbooks that are not currently open, they will be converted to và displayed as #REF errors.

What to lớn do In the Compatibility Checker, click Find lớn locate the cells that contain formulas with structured references to lớn tables in other workbooks so that you can change them to lớn avoid #REF errors.

One or more cells in this workbook contain data validation rules which refer lớn more than 8192 discontinuous areas of cells. These data validation rules will not be saved.

What it means Beginning with Excel 2010, data validation rules can refer to more than 8192 discontinuous areas of cells. In Excel 97-2007, this type of data validation rule is not racingbananas.comed & won"t be available.

What to do In the Compatibility Checker, click Find khổng lồ locate cells that contain data validation rules that refer khổng lồ more than 8192 discontinuous areas of cells, và then make the necessary changes.

One or more cells in this workbook contain data validation rules which refer lớn values on other worksheets. These data validation rules will not be racingbananas.comed in earlier versions of Excel.

What it means Beginning with Excel 2010, you can implement data validation rules that refer khổng lồ values on other worksheets. This is not racingbananas.comed in Excel 97-2007.

What to do In the Compatibility Checker, click Find khổng lồ locate the cells that contain data validation rules that refer lớn values on other worksheets, & then make the necessary changes so that the data validation rules refer lớn values on the same worksheet.

One or more cells in this workbook contain data validation rules which refer to lớn values on other worksheets. These data validation rules will not be racingbananas.comed in earlier versions of Excel.

What it means Beginning with Excel 2010, you can use data validation rules that refer to values on other worksheets. In Excel 97-2007, this type of data validation is not racingbananas.comed and cannot be displayed on the worksheet.

However, all data validation rules remain available in the workbook và are applied when the workbook is opened again in Excel 2010 và later, unless the rules were edited in Excel 97-2007.

What to lớn do In the Compatibility Checker, click Find to locate cells that contain data validation rules that refer khổng lồ values on other worksheets, và then make the necessary changes on the Settings tab of the Data Validation dialog box (Data tab, Data Tools group).

This workbook contains a Data Consolidation Range with references khổng lồ cells outside of the row và column limits of the selected file format. Formula references khổng lồ data in this region will be adjusted and may not display correctly in an earlier version of Excel.

What it means Beginning with Excel 2010, data consolidation ranges can contain formulas that refer to data outside of the row and column limit of the selected tệp tin format. In Excel 97-2003, worksheet kích thước of 65,536 rows tall by 256 columns wide. Formula references khổng lồ data in cells outside of this column & row limit are adjusted and may not display correctly.

What lớn do In the Compatibility Checker, click Find to lớn locate data consolidation ranges that contain formula references to lớn data outside of the row & column limit of Excel 97-2003, and then make the necessary changes.

Minor loss of fidelity

Solution

Some array formulas in this workbook refer to an entire column. In earlier versions of Excel, these formulas may be converted lớn #NUM! errors when they are recalculated.

What it means Beginning with Excel 2007, array formulas that refer khổng lồ an entire column will be converted to & displayed as #NUM! errors when they are recalculated in Excel 97-2003.

What khổng lồ do In the Compatibility Checker, click Find to locate the array formulas that refer to lớn an entire column so that you can make the necessary changes to lớn avoid #NUM errors.

One or more defined names in this workbook contain formulas that use more than the 255 characters allowed in the selected file format. These formulas will be saved but will be truncated when edited in earlier versions of Excel.

What it means When named ranges in formulas exceed the 255 character limit that is racingbananas.comed in Excel 97-2003, the formula will work correctly, but it will be truncated in the Name dialog box & cannot be edited.

What to do In the Compatibility Checker, click Find to lớn locate cells that contain named ranges in formulas, & then make the necessary changes so that users can edit the formulas in Excel 97-2003.

Some formulas in this workbook are linked khổng lồ other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned.

What it means When formulas in a workbook are linked khổng lồ other workbooks that are closed, they can only display up lớn 255 characters when they are recalculated in Excel 97-2003. The formula results might be truncated.

What lớn do Find the cells that contain formulas that links to other workbooks that are closed so that you can verify the links and make the necessary changes lớn avoid truncated formula results in Excel 97-2003.

A Data Validation formula has more than 255 characters.

What it means When Data Validation formulas exceed the 255 character limit that is racingbananas.comed in Excel 97-2003, the formula will work correctly, but it will be truncated and cannot be edited.

What khổng lồ do In the Compatibility Checker, click Find to locate cells that contain Data Validation formulas, và then use fewer characters in the formula so that users can edit them in Excel 97-2003.

Some formulas contain arrays with more elements than are racingbananas.comed by the selected file format. Arrays with more than 256 columns or 65536 rows will not be saved và may produce different results.

What it means Beginning with Excel 2010, you can use array formulas that contain elements for more than 256 columns and 65536 rows. In Excel 2007, this exceeds the limit for array elements and might return different results.

What to lớn do In the Compatibility Checker, click Find lớn locate cells that contain array formulas that have more elements than are racingbananas.comed in earlier versions of Excel, & then make the necessary changes.

This workbook contains custom descriptions for VBA User Defined Functions. All custom descriptions will be removed.

What it means Beginning with Excel 2010, you can use Visual Basic for Applications (VBA) khổng lồ create User-Defined Functions (UDFs) with custom descriptions. Custom descriptions are not racingbananas.comed in Excel 97-2007 & will be removed.

What to do No kích hoạt is needed because all custom descriptions will be removed.

For more information about how khổng lồ resolve one or more of these compatibility issues, see What"s New: Changes made to Excel functions.

Unracingbananas.comed conditional formatting features

Unracingbananas.comed conditional formatting features can cause the following compatibility issues, leading lớn a significant loss of functionality.

Significant loss of functionality

Solution

Some cells have more conditional formats than are racingbananas.comed by the selected file format. Only the first three conditions will be displayed in earlier versions of Excel.

What it means Beginning with Excel 2007, conditional formatting can contain up khổng lồ sixty-four conditions, but in Excel 97-2003, you will see the first three conditions only.

However, all conditional formatting rules remain available in the workbook và are applied when the workbook is opened again in Excel 2007 & later, unless the rules were edited in Excel 97-2003.

What to lớn do In the Compatibility Checker, click Find khổng lồ locate cells that have conditional formatting applied that use more than three conditions, & then make the necessary changes khổng lồ use no more than three conditions.

Some cells have overlapping conditional formatting ranges. Earlier versions of Excel will not evaluate all of the conditional formatting rules on the overlapping cells. The overlapping cells will show different conditional formatting.

What it means Overlapping conditional formatting ranges are not racingbananas.comed in Excel 97-2003, and the conditional formatting is not displayed as expected.

However, all conditional formatting rules remain available in the workbook và are applied when the workbook is opened again in Excel 2007 & later, unless the rules were edited in Excel 97-2003.

What to do In the Compatibility Checker, click Find to lớn locate cells that have overlapping conditional formatting ranges, and then make the necessary changes lớn avoid overlap.

One or more cells in this workbook contain a conditional formatting type that is not racingbananas.comed in earlier versions of Excel, such as data bars, màu sắc scales, or icon sets.

What it means In Excel 97-2003, you will not see conditional formatting types, such as data bars, màu sắc scales, icon sets, đứng top or bottom ranked values, above or below average values, chất lượng or duplicate values, and table column comparison to determine which cells to lớn format.

However, all conditional formatting rules remain available in the workbook & are applied when the workbook is opened again in Excel 2007 và later, unless the rules were edited in Excel 97-2003.

What khổng lồ do In the Compatibility Checker, click Find to locate cells that have conditional formatting types that are new in Excel 2007 và later, and then make the necessary changes to use only formatting types that are racingbananas.comed in the earlier versions of Excel.

Some cells contain conditional formatting with the "Stop if True" option cleared. Earlier versions of Excel vì chưng not recognize this option and will stop after the first true condition.

What it means In Excel 97-2003, conditional formatting without stopping when the condition has been met is not an option. Conditional formatting is no longer applied after the first condition is true.

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.

What lớn do In the Compatibility Checker, click Find khổng lồ locate cells that contain conditional formatting with the Stop if True option cleared, và then click Fix lớn resolve the compatibility issue.

One or more cells in this workbook contain a conditional formatting type on a nonadjacent range (such as top/bottom N, top/bottom N%, above/below average, or above/below standard deviation). This is not racingbananas.comed in earlier versions of Excel.

What it means In Excel 97-2003, you will not see conditional formatting in nonadjacent cells.

However, all conditional formatting rules remain available in the workbook and are applied when the workbook is opened again in Excel 2007 và later, unless the rules were edited in Excel 97-2003.

What to do In the Compatibility Checker, click Find to lớn locate cells that contain a conditional formatting type on a nonadjacent range, & then make the necessary changes to lớn use conditional formatting rules that are available in earlier versions of Excel.

Some PivotTables in this workbook contain conditional formatting that may not function correctly in earlier versions of Excel. The conditional formatting rules will not display the same results when you use these PivotTables in earlier versions of Excel.

What it means Conditional formatting results you see in Excel 97-2003 PivotTable reports will not be the same as in PivotTable reports created in Excel 2007 & later.

However, all conditional formatting rules remain available in the workbook & are applied when the workbook is opened again in Excel 2007 and later, unless the rules were edited in Excel 97-2003.

What khổng lồ do In the Compatibility Checker, click Find to lớn locate PivotTable report fields that contain conditional formatting rules, and then apply conditional formatting rules that are available in the earlier versions of Excel.

One or more cells in this workbook contain conditional formatting which refers to lớn values on other worksheets. These conditional formats will not be racingbananas.comed in earlier versions of Excel.

What it means In Excel 97-2007, conditional formatting that refers lớn values on other worksheets is not displayed.

However, all conditional formatting rules remain available in the workbook và are applied when the workbook is opened again in Excel 2010 & later, unless the rules were edited in Excel 97-2007.

What lớn do In the Compatibility Checker, click Find khổng lồ locate cells that contain conditional formatting that refers to lớn values on other worksheets, & then apply conditional formatting that does not refer khổng lồ values on other worksheets.

One or more cells in this workbook contain conditional formatting using the "Text that contains" format with a cell reference or formula. These conditional formats will not be racingbananas.comed in earlier versions of Excel.

What it means In Excel 97-2007, conditional formatting that use formulas for text that contains rules is not displayed on the worksheet.

However, all conditional formatting rules remain available in the workbook & are applied when the workbook is opened again in Excel 2010 and later, unless the rules were edited in Excel 97-2007.

What to lớn do In the Compatibility Checker, click Find khổng lồ locate cells that contain conditional formatting that uses formulas for text that contains rules, & then apply conditional formatting that is racingbananas.comed in earlier versions of Excel.

One or more cells in this workbook contain a rule that will not be racingbananas.comed in earlier versions of Excel because there is a formula error in its range.

What it means In Excel 97-2007, conditional formatting that use range-based rules cannot be displayed correctly on the worksheet when the range-based rules contain formula errors.

What khổng lồ do In the Compatibility Checker, click Find lớn locate cells that contain range-based rules that contain formula errors, and then make the necessary changes so that range-based rules vì not contain formula errors.

One or more cells in this workbook contain a conditional formatting icon set arrangement that is not racingbananas.comed in earlier versions of Excel.

What it means In Excel 97-2003, conditional formatting that displays a specific icon set arrangement is not racingbananas.comed and the icon set arrangement is not displayed on the worksheet.

However, all conditional formatting rules remain available in the workbook và are applied when the workbook is opened again in Excle 2007 & later, unless the rules were edited in Excel 97-2003.

What lớn do In the Compatibility Checker, click Find to locate cells that contain conditional formatting that display a specific icon mix arrangement, & then make sure that conditional formatting does not display that icon set arrangement.

One or more cells in this workbook contain a data bar rule that uses a "Negative Value" setting. These data bars will not be racingbananas.comed in e