Data type compatibility issues in Excel

The Compatibility Checker found one or more compatibility issues related to data types.

Important: Before you continue saving the workbook to an earlier file format, you should address issues that cause a significant loss of functionality so that you can prevent permanent loss of data or incorrect functionality.

Issues that cause a significant loss of functionality

Issue

Solution

This workbook contains data types that are not supported in earlier versions of Excel. In earlier versions, these data types will either show an error, or be replaced with other similar types. Those types may not look or act the same.

What it means    If you are an Office 365 subscriber and you have the latest version of Office installed, you can use linked data types. Linked data types are not supported in earlier versions of Excel. The cells will either show an error, or be replaced with another similar data type.

What to do    In the Compatibility Checker, click Find to locate the cells containing the linked data types, then convert them to text before saving to an earlier file format. To convert a cell with a linked data type to text, right-click the cell with the data type, and then click Data Type > Convert to Text.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×