What it means Beginning with Excel , 1, global font types are available, and you can use up to of them per workbook. Excel supports less unique font formats. What to do To avoid losing specific font formats that you want to keep available in Excel , you can remove some font formats that are not as important to keep. For more information about how to resolve one or more of these compatibility issues, see the following articles:. Move or copy cells and cell contents.
Headers and footers in worksheets. Unsupported Excel table features can cause the following compatibility issues, leading to a minor loss of fidelity. 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 , the range will no longer be in table format. What to 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, and then use only formulas that are available in the total row.
A table in this workbook does not display a header row. What it means In Excel , a table cannot be displayed without a header row. What to do In the Compatibility Checker, click Find to locate the table that is displayed without a header row, and then display a header row. A table style is applied to a table in this workbook.
Table style formatting cannot be displayed in earlier versions of Excel. What it means In Excel , theme-based table styles are not available and cannot be displayed.
What to do In the Compatibility Checker, click Find to locate the table that has a table style applied, remove that table style, and 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 What to do In the Compatibility Checker, click Find to locate the table that is connected to an external data source, and then disconnect the table from the external data source. In Excel , you can then connect the data to the external data source again. Table functionality will be lost, as well as the ability to refresh or edit the connection. Alternative text is applied to a table in this workbook.
Alternative text on tables will be removed in versions prior to Excel What it means Alternative text is not available in Excel , and cannot be displayed in these earlier versions of Excel. What to do In the Compatibility Checker, click Find to 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. For more information about how to resolve one or more of these compatibility issues, see the following article:.
Create or delete an Excel table in a worksheet. Unsupported PivotTable features can cause the following compatibility issues, leading to a significant loss of functionality or a minor loss of fidelity. A PivotTable in this workbook exceeds former limits and will be lost if it is saved to earlier file formats.
What it means Beginning with Excel , a PivotTable report supports 1,, unique items per field, but in Excel , only 32, items per field are supported. Save the workbook to Excel format, and then re-create this PivotTable report in Compatibility Mode.
A PivotTable in this workbook contains conditional formatting rules that are applied to 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 cells in collapsed rows or columns will be lost in Excel What to do In the Compatibility Checker, click Find to 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 file 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 What to 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 server are not displayed in the earlier version of Excel. What to do Make sure that you publish the what-if analysis changes before you open 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. The PivotTable cannot be displayed in Excel 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, and then remove any duplicate measures so that only one measure remains. A PivotTable or data connection in this workbook contains server settings which do 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 server settings that are not available in Excel will be lost. What to do Verify that the server 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.
These custom outputs will not be saved, and will be replaced by the original values from the data source. Alternative text is applied to a PivotTable in this workbook. Alternative text on PivotTables will be removed in versions prior to Excel 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 and cannot be displayed. What to do In the Compatibility Checker, click Find to locate the PivotTable report that has a PivotTable style applied, remove that PivotTable style, and then manually apply PivotTable formatting that is supported in the earlier versions of Excel. A PivotTable in this workbook will not work in versions prior to Excel What it means A PivotTable report you create in Excel and later cannot be refreshed in Excel What to do In the Compatibility Checker, click Find to locate the PivotTable report that is created in the current file format.
Save the workbook to Excel format, and then re-create this PivotTable report in Compatibility Mode so that you can open it in Excel 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 form alone or in combination with tabular and outline form to keep related data from spreading horizontally off of the screen and to help minimize scrolling is not available in Excel , and fields will be displayed in tabular form. 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 open and save the workbook in an earlier version of Excel.
Slicers will not work in earlier versions of Excel. What it means Slicers were not introduced until Excel What to do In the earlier version of Excel, you can use PivotTable filters to filter data. Slicers will not be saved. What it means Slicers are not supported in Excel 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, and the slicers will be lost.
What to do Use PivotTable filters instead of slicers to filter the data. A slicer style exists in this workbook, and is not supported 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 file format of an earlier version of Excel.
What to do Change the custom slicer style to 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 supported in Excel , and the labels will be lost when you refresh the PivotTable report in the earlier version of Excel.
Add, change, or clear conditional formats. Unsupported sorting and filtering features can cause the following compatibility issues, leading to a minor loss of fidelity. 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 , you can apply sort states with up to sixty-four sort conditions to sort data by, but Excel supports sort states with up to three conditions only. To avoid losing sort state information in Excel , you may want to change the sort state to one that uses no more than three conditions.
In Excel , you can also 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 and later, unless the sort state information is edited in Excel What to 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. What it means Beginning with Excel , you can sort by a custom list. To get similar sorting results in Excel , you can group the data that you want to sort, and then sort the data manually. What to do In the Compatibility Checker, click Find to 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. What it means Beginning with Excel , you can sort data by a specific format, such as cell color, font color, or icon sets. In Excel , you can sort only text.
What to 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.
Some data in this workbook is filtered in a way that is not supported 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 , you can apply filters that are not supported in Excel To avoid losing filter functionality, you may want to clear the filter before you save the workbook in an earlier Excel file format.
In Excel , 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 and later, unless the filter state information is edited in Excel What to do In the Compatibility Checker, click Find to locate the data that has been filtered, and then you can clear the filter to unhide the rows that are hidden.
Some data in this workbook is filtered by a cell color. What it means Beginning with Excel , you can filter by a cell color, font color, or icon set — these methods are not supported in Excel Some data in this workbook is filtered by a font color.
Some data in this workbook is filtered by a cell icon. Some data in this workbook is filtered by more than two criteria.
What it means Beginning with Excel , you can filter data by more than two criteria. Some data in this workbook is filtered by a grouped hierarchy of dates, resulting in more than two criteria. What it means Beginning with Excel , you can filter dates by a grouped hierarchy. Because this is not supported in Excel , you may want to ungroup the hierarchy of dates. If you're using Excel , press the Office button , then Excel Options. Unsupported formula features can cause the following compatibility issues, leading to a significant loss of functionality or a minor loss of fidelity.
Some worksheets contain more array formulas that refer to other worksheets than are supported by the selected file format. What it means Beginning with Excel , workbook arrays that refer to other worksheets are limited only by available memory, but in Excel , worksheets can only contain up to 65, workbook arrays that refer to other worksheets. What to do In the Compatibility Checker, click Find to locate cells that contain array formulas that refer to another worksheet, and then make the necessary changes to avoid VALUE!
What it means Beginning with Excel , the maximum length of formula contents is 8, characters, and the maximum internal formula length is 16, bytes. In Excel , the maximum length of formula contents is 1, characters, and the maximum internal formula length is 1, bytes.
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 , and then make the necessary changes to avoid VALUE! Some formulas have more levels of nesting than are supported by the selected file format. What it means Beginning with Excel , a formula can contain up to 64 levels of nesting, but in Excel , the maximum levels of nesting is only 7.
Share your workbook and work faster together on the latest version in real time. Work within an Excel file from mobile, desktop, and web with Microsoft With XML-based file formats, documents are smaller, more robust, and integrate with more information systems and external data systems. The Quick Access toolbar provides access to your most frequently used commands in Excel, no matter which tab of the Ribbon is active. Review and edit documents from anywhere with the Office mobile apps.
Excel recommends the best ways to present your data based on the context and recent work patterns. New bars, colors and icons help to highlight trends. Microsoft plans include premium versions of these applications plus other services that are enabled over the internet, including online storage with OneDrive and Skype minutes for home use.
Microsoft plans are available as a monthly or annual subscription. Learn more. See system requirements for compatible versions of Windows and macOS, and for other feature requirements.
However, internet access is required to install and activate all the latest releases of Office suites and all Microsoft subscription plans. For Microsoft plans, internet access is also needed to manage your subscription account, for example to install Office on other PCs or to change billing options. Internet access is also required to access documents stored on OneDrive, unless you install the OneDrive desktop app.
You should also connect to the internet regularly to keep your version of Office up to date and benefit from automatic upgrades. To reactivate your Office applications, reconnect to the internet. Documents that you have created belong fully to you. If you purchase an auto-renew subscription, your subscription starts when you complete your purchase. You can purchase auto-renew subscriptions from Microsoft If you purchase a pre-paid subscription, your subscription starts when you activate your subscription and land on your My Account page.
File Name:. Date Published:. File Size:. System Requirements Supported Operating System. Browse All News Articles. Windows 11 Performance. Edge Shopping Features. Spotify Lyrics.
Windows 11 Mute Keyboard Shortcut. Edge Buy Now Pay Later. Windows 10 November Update. Apple Self Service Repair. Windows 10 Annual Updates. Cortana Alexa Integration.
Adobe Apps Deal. Find Downloaded Files on an iPhone. Use Your iPhone as a Webcam. Hide Private Photos on iPhone. Take Screenshot by Tapping Back of iPhone. Should You Upgrade to Windows 11? Browse All Windows Articles. OneDrive Windows 7 and 8.
0コメント