Use Excel With Earlier Versions Of Excel

Excel for turkcefilmizle.org 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 to 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: Use excel with earlier versions of excel

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 xuất hiện a workbook that was created in an earlier version of Excel & 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 lớn work in the current file format but have to nội dung a workbook with people who use earlier versions of Excel, you can check that the data is compatible with earlier versions of Excel. You can then make the necessary changes khổng lồ 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 and later, when you xuất hiện a workbook that was created in Excel 97-2003, it is automatically opened in Compatibility Mode, và you see Compatibility Mode in square brackets next to the file name in the Excel title bar.

The tệp tin 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, và you vị not have the option lớn include any new features when you work in a workbook in Compatibility Mode.

Exit Compatibility mode

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

New features that are not turkcefilmizle.orged in earlier versions of Excel

Not all new features are turkcefilmizle.orged in earlier versions of Excel. When you work in Compatibility Mode or want to 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 lớn avoid the loss of data or functionality in an earlier version of Excel, you can then make the necessary changes to your current workbook.

When you save a workbook khổng lồ an Excel 97-2003 tệp tin 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 check an Excel workbook for compatibility with earlier versions of Excel.

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

*

Unturkcefilmizle.orged worksheet features

Unturkcefilmizle.orged worksheet features can cause the following compatibility issues, leading to lớn 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 file 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 2016 or earlier versions.

What to vị lớn preserve the labels, avoid saving the workbook in .xls format. If you need people who can’t xuất hiện .xlsx files to lớn be able to mở cửa the workbook, consider opening the workbook in Excel for the web và sending the tệp tin URL lớn them at an thư điện tử address that is registered as a turkcefilmizle.org Account. 

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

What it means Beginning with Excel 2007, the worksheet form size 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 lớn locate the cells và ranges that fall outside the row and column limits, select those rows and columns, and then place them inside the column & row limits of the worksheet or on another worksheet by using the Cut & Paste commands.

*

This workbook contains Scenarios with references lớn cells outside of the row and column limits of the selected tệp tin 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 và 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 to lớn 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, và then change the reference to lớn 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 turkcefilmizle.orged 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, và Korean Lunar. However, these calendar formats are not turkcefilmizle.orged in Excel 97-2003.

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

This workbook contains dates in a calendar format that is not turkcefilmizle.orged 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 bầu Buddhist or Arabic Hijri. In Excel 97-2003, these calendar types can only be edited in Gregorian.

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

This workbook contains more cells with data than are turkcefilmizle.orged in earlier versions of Excel. Earlier versions of Excel will not be able to xuất hiện 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 club 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 khổng lồ 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 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 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 và 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, & then make the necessary changes. For example, you could apply conditional formatting instead of or in addition to lớn the sparklines that won"t be displayed in the earlier version of Excel.

Minor loss of fidelity

Solution

Earlier versions of Excel do not turkcefilmizle.org color formatting in header and 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 màu sắc formatting in headers and footers in Excel 97-2003.

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

*

This workbook contains worksheets that have even page or first page headers & footers. These page headers and 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 và footer text on even pages or on the first page. In Excel 97-2003, even page or first page headers và footers cannot be displayed, but they remain available for display when you mở cửa the workbook in Excel 2007 và later again.

What to lớn do If you frequently save a workbook lớn Excel 97-2003 file format, it is best not to 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 turkcefilmizle.orged by the selected file format. These formats will be converted to the closest format available.

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

What to lớn 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 something else. To lớn avoid duplication of formats, you can change or remove the cell formatting & cell styles that are not turkcefilmizle.orged before you save the workbook lớn Excel 97-2003 file format.

This workbook contains more unique cell formats than are turkcefilmizle.orged 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 chất lượng cell formats, but in Excel 97-2003, you can only use up to 4,000 quality cell formats. Chất lượng cell formats include any specific combination of formatting that is applied in a workbook.

What lớn do to 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 to lớn keep.

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

What it means Beginning with Excel 2007, 1,024 global phông types are available, và you can use up lớn 512 of them per workbook. Excel 97-2003 turkcefilmizle.orgs less quality font formats.

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

For more information about how khổng lồ resolve one or more of these compatibility issues, see the following articles:

Unturkcefilmizle.orged Excel table features

Unturkcefilmizle.orgedExcel table features can cause the following compatibility issues, leading lớn 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 and text remain intact in Excel 97-2003, the range will no longer be in table format.

What to do In the Compatibility Checker, click Find khổng lồ locate the table that contains a custom formula or text, remove that formula or text from the total row, & 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 danh mục has headers kiểm tra 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 to lớn locate the table that is displayed without a header row, and 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 và cannot be displayed.

What to lớn do In the Compatibility Checker, click Find to locate the table that has a table style applied, remove that table style, và then format the table manually.

A table in this workbook is connected lớn 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 lớn locate the table that is connected lớn an external data source, & then disconnect the table from the external data source. In Excel 97-2003, you can then connect the data to the external data source again.

A table in this workbook has a read-only connection khổng lồ a Windows SharePoint Services List. Table functionality will be lost, as well as the ability khổng lồ 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 khổng lồ do In the Compatibility Checker, click Find to lớn locate the table that has a read-only connection lớn a turkcefilmizle.org SharePoint Foundation List, & then disconnect the table from the SharePoint List. In Excel 2003, you can then import the SharePoint danh mục as a read/write list.

You can also create a read/write menu 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 to lớn a table in this workbook. Alternative text on tables will be removed in versions prior to Excel 2010.

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

What to do In the Compatibility Checker, click Find to lớn locate the Excel table that contains alternative text. To 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 comment that contains the text.

Right-click anywhere in the table, click Table, and then click Alternative Text. In the Description box, select the alternative text, and then press CTRL+C khổng lồ copy it.

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

Unturkcefilmizle.orged PivotTable features

Unturkcefilmizle.orged PivotTable 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

A PivotTable in this workbook exceeds former limits và will be lost if it is saved khổng lồ earlier file 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 turkcefilmizle.orgs 1,048,576 unique items per field, but in Excel 97-2003, only 32,500 items per field are turkcefilmizle.orged.

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 lớn Excel 97-2003 format, và then re-create this PivotTable report in Compatibility Mode.

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

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

What to do In the Compatibility Checker, click Find khổng lồ locate the collapsed rows or columns that contain conditional formatting rules, và 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 khổng lồ do to lớn 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 khổng lồ the hệ thống are not displayed in the earlier version of Excel.

What khổng lồ 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 lớn do In the Compatibility Checker, click Find to lớn locate the PivotTable report that contains a data axis upon which more than one of the same measure appears, và then remove any duplicate measures so that only one measure remains.

A PivotTable or data connection in this workbook contains server settings which vày 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 hệ thống settings you use are compatible with earlier versions of Excel and 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, and will be replaced by the original values from the data source.

What it means The Show Values As feature is not turkcefilmizle.orged 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 khổng lồ locate the PivotTables that contain custom value outputs, & then remove those outputs (PivotTable Tools, Options tab, Calculations group, Show Values As button).

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

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

What khổng lồ do In the Compatibility Checker, click Find to locate the PivotTable that contains alternative text. Khổng lồ 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 phản hồi 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, & then press CTRL+C lớn 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 and cannot be displayed.

What to lớn do In the Compatibility Checker, click Find khổng lồ locate the PivotTable report that has a PivotTable style applied, remove that PivotTable style, và then manually apply PivotTable formatting that is turkcefilmizle.orged in the earlier versions of Excel.

A PivotTable in this workbook will not work in versions prior to lớn 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 và later cannot be refreshed in Excel 97-2003.

What lớn do In the Compatibility Checker, click Find to lớn locate the PivotTable report that is created in the current file format. Save the workbook khổng lồ Excel 97-2003 format, và 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 khổng lồ tabular form.

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

What khổng lồ do In the Compatibility Checker, click Find to locate the PivotTable report that has fields in a compact form, & then change that format to outline size or tabular size as needed by clearing the Merge và center cells with labels kiểm tra 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 xuất hiện and save the workbook in an earlier version of Excel.

What to 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 khổng lồ enable & disable field buttons to display the ones that you want (PivotChart Tools, Analyze tab, Show/Hide group, Field Buttons button).

This workbook contains Slicers that can be used to lớn filter PivotTables & 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 khổng lồ 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 turkcefilmizle.orged 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 lớn do Use PivotTable filters instead of slicers khổng lồ filter the data.

A slicer style exists in this workbook, and is not turkcefilmizle.orged 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 lớn the file format of an earlier version of Excel.

What lớn do Change the custom slicer style lớn a built-in slicer style before you save the workbook lớn an earlier Excel tệp tin 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 turkcefilmizle.orged in Excel 97-2007, & the labels will be lost when you refresh the PivotTable report in the earlier version of Excel.

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

For more information about how khổng lồ resolve one or more of these compatibility issues, see the following article:

Unturkcefilmizle.orged sorting & filtering features

Unturkcefilmizle.orged sorting and filtering features can cause the following compatibility issues, leading to 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 to sixty-four sort conditions to sort data by, but Excel 97-2003 turkcefilmizle.orgs sort states with up lớn three conditions only. Lớn avoid losing sort state information in Excel 97-2003, you may want to change the sort state lớn 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 và later, unless the sort state information is edited in Excel 97-2003.

What to lớn do In the Compatibility Checker, click Find to locate the data that has been sorted with more than three conditions, and 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. To lớn 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 and 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 lớn do In the Compatibility Checker, click Find lớn locate the data that has been sorted by a custom list, & 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 Thiện Nữ U Hồn 3 1991 A Chinese Ghost Story, Thiện Nữ U Hồn 3

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

However, all sort state information remains available in the workbook and 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 lớn 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 turkcefilmizle.orged 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 turkcefilmizle.orged in Excel 97-2003. To avoid losing filter functionality, you may want to 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 và is applied when the workbook is opened again in Excel 2007 & 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, & 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 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, phông color, or icon set — these methods are not turkcefilmizle.orged in Excel 97-2003. 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 file format. In Excel 97-2003, you can then filter the data manually.

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

What to do In the Compatibility Checker, click Find to 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 và Filter, và then click Clear lớn clear the filter.

Some data in this workbook is filtered by a font 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 turkcefilmizle.orged in Excel 97-2003. 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 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 and later, unless the filter state information is edited in Excel 97-2003.

What lớn 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. On the Home tab, in the Editing group, click Sort & Filter, & then click Clear lớn 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, fonts color, or icon set — these methods are not turkcefilmizle.orged 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 & 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, 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 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. Lớn avoid losing filter functionality, you may want 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 và later, unless the filter 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 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, & 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 turkcefilmizle.orged in Excel 97-2003, you may want to lớn ungroup the hierarchy of dates. 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.

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

What to 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 & Filter, và then click Clear to lớn 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.

Unturkcefilmizle.orged formula features

Unturkcefilmizle.orged formula features can cause the following compatibility issues, leading to lớn 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 other worksheets than are turkcefilmizle.orged by the selected file format. Some of these array formulas will not be saved và will be converted khổng lồ #VALUE! errors.

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

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

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

What it means Beginning with Excel 2007, the maximum length of formula contents is 8,192 characters, & the maximum internal formula length is 16,384 bytes. In Excel 97-2003, the maximum length of formula contents is 1,024 characters, & 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 lớn an earlier Excel file format.

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

Some formulas have more levels of nesting than are turkcefilmizle.orged by the selected file format. Formulas with more than seven levels of nesting will not be saved and will be converted to lớn #VALUE! errors.

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

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

Some formulas contain functions that have more arguments than are turkcefilmizle.orged by the selected file format. Formulas that have more than 30 arguments per function will not be saved and will be converted to lớn #VALUE! errors.

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

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

Some formulas use more operands than are allowed by the selected tệp tin format. These formulas will not be saved & will be converted to #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 lớn do In the Compatibility Checker, click Find to locate the cells that contain formulas with more than 40 operands, and then make the necessary changes to avoid #VALUE! errors.

Some formulas contain functions with more arguments than are turkcefilmizle.orged by the selected tệp tin format. Formulas with more than 29 arguments lớn a function will not be saved và will be converted khổng lồ #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 lớn only 29.

What lớn do In the Compatibility Checker, click Find to locate the cells that contain functions that use more than 29 arguments, và then make the necessary changes lớn avoid #VALUE! errors. You may have to lớn use VBA code lớn 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 and 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 to the formula, for example, =_xlfn.IFERROR (1,2).

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

Compatibility functions are available for all functions that have been renamed. Khổng lồ 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 turkcefilmizle.orged in the selected file format. These references will be converted to lớn cell references.

What it means Beginning with Excel 2007, you can use structured references khổng lồ make it much easier and more intuitive khổng lồ 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 turkcefilmizle.orged in Excel 97-2003, và structured references will be converted lớn cell references.

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

Some formulas contain references khổng lồ tables in other workbooks that are not currently xuất hiện in this instance of Excel. These references will be converted to lớn #REF on save to lớn 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 to lớn 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 turkcefilmizle.orged in Excel 97-2003, and structured references will be converted lớn cell references. However, if the structured references point to tables in other workbooks that are not currently open, they will be converted to và displayed as #REF errors.

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

One or more cells in this workbook contain data validation rules which refer khổng lồ 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 turkcefilmizle.orged và won"t be available.

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

One or more cells in this workbook contain data validation rules which refer to values on other worksheets. These data validation rules will not be turkcefilmizle.orged 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 turkcefilmizle.orged in Excel 97-2007.

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

One or more cells in this workbook contain data validation rules which refer to values on other worksheets. These data validation rules will not be turkcefilmizle.orged in earlier versions of Excel.

What it means Beginning with Excel 2010, you can use data validation rules that refer to lớn values on other worksheets. In Excel 97-2007, this type of data validation is not turkcefilmizle.orged và cannot be displayed on the worksheet.

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

What khổng lồ do In the Compatibility Checker, click Find lớn locate cells that contain data validation rules that refer lớn values on other worksheets, & 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 to cells outside of the row và column limits of the selected tệp tin 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 lớn data outside of the row and column limit of the selected tệp tin format. In Excel 97-2003, worksheet size of 65,536 rows tall by 256 columns wide. Formula references to data in cells outside of this column và row limit are adjusted & may not display correctly.

What khổng lồ do In the Compatibility Checker, click Find khổng lồ locate data consolidation ranges that contain formula references khổng lồ 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 lớn an entire column. In earlier versions of Excel, these formulas may be converted to lớn #NUM! errors when they are recalculated.

What it means Beginning with Excel 2007, array formulas that refer lớn an entire column will be converted to và displayed as #NUM! errors when they are recalculated in Excel 97-2003.

What lớn do In the Compatibility Checker, click Find to lớn locate the array formulas that refer lớn an entire column so that you can make the necessary changes 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 tệp tin 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 turkcefilmizle.orged in Excel 97-2003, the formula will work correctly, but it will be truncated in the Name dialog box and cannot be edited.

What to do In the Compatibility Checker, click Find khổng lồ locate cells that contain named ranges in formulas, và then make the necessary changes so that users can edit the formulas in Excel 97-2003.

Some formulas in this workbook are linked lớn 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 to other workbooks that are closed, they can only display up to 255 characters when they are recalculated in Excel 97-2003. The formula results might be truncated.

What to lớn do Find the cells that contain formulas that liên kết to other workbooks that are closed so that you can verify the link and make the necessary changes to 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 turkcefilmizle.orged in Excel 97-2003, the formula will work correctly, but it will be truncated & cannot be edited.

What khổng lồ do In the Compatibility Checker, click Find to locate cells that contain Data Validation formulas, & 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 turkcefilmizle.orged by the selected tệp tin 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 & 65536 rows. In Excel 2007, this exceeds the limit for array elements and might return different results.

What khổng lồ do In the Compatibility Checker, click Find to lớn locate cells that contain array formulas that have more elements than are turkcefilmizle.orged 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 turkcefilmizle.orged in Excel 97-2007 và will be removed.

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

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

Unturkcefilmizle.orged conditional formatting features

Unturkcefilmizle.orged conditional formatting features can cause the following compatibility issues, leading to a significant loss of functionality.

Significant loss of functionality

Solution

Some cells have more conditional formats than are turkcefilmizle.orged by the selected tệp tin 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 lớn locate cells that have conditional formatting applied that use more than three conditions, and 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 turkcefilmizle.orged in Excel 97-2003, and the conditional formatting is not displayed as expected.

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 to do In the Compatibility Checker, click Find to lớn locate cells that have overlapping conditional formatting ranges, và then make the necessary changes khổng lồ avoid overlap.

One or more cells in this workbook contain a conditional formatting type that is not turkcefilmizle.orged 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 đầu or bottom ranked values, above or below average values, chất lượng or duplicate values, and table column comparison to lớn determine which cells to lớn format.

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 to lớn locate cells that have conditional formatting types that are new in Excel 2007 và later, and then make the necessary changes khổng lồ use only formatting types that are turkcefilmizle.orged in the earlier versions of Excel.

Some cells contain conditional formatting with the "Stop if True" option cleared. Earlier versions of Excel do not recognize this option và 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 và 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, and then click Fix khổng lồ 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 turkcefilmizle.orged 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 và 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 lớn locate cells that contain a conditional formatting type on a nonadjacent range, & then make the necessary changes khổng lồ 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 and 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 locate PivotTable report fields that contain conditional formatting rules, & 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 turkcefilmizle.orged in earlier versions of Excel.

What it means In Excel 97-2007, conditional formatting that refers to 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 and later, unless the rules were edited in Excel 97-2007.

What to lớn do In the Compatibility Checker, click Find to lớn locate cells that contain conditional formatting that refers to values on other worksheets, và 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 turkcefilmizle.orged 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 và are applied when the workbook is opened again in Excel 2010 và later, unless the rules were edited in Excel 97-2007.

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

One or more cells in this workbook contain a rule that will not be turkcefilmizle.orged 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 bởi not contain formula errors.

One or more cells in this workbook contain a conditional formatting icon phối arrangement that is not turkcefilmizle.orged in earlier versions of Excel.

What it means In Excel 97-2003, conditional formatting that displays a specific icon set arrangement is not turkcefilmizle.orged và the icon mix 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 lớn locate cells that contain conditional formatting that display a specific icon phối arrangement, và 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 turkcefilmizle.orged in earlier versions of Excel.

W

Leave a Reply

Your email address will not be published. Required fields are marked *

  • Phim thần tài đến 1999

  • Trần huyền linh hòa phát

  • Khe nứt san andreas vietsub

  • Xem phim tân ỷ thiên đồ long ký tập 17 vietsub

  • x