Graphics, object, or ActiveX control compatibility issues in Excel for Windows The Compatibility Checker found one ...
Graphics, object, or ActiveX control compatibility issues in Excel for Windows
The Compatibility Checker found one or more compatibility issues related to graphics, objects, or ActiveX controls.
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 minor loss of fidelity might or might not have to be resolved before you continue saving the workbook—data or functionality is not lost, but the workbook might not look or work exactly the same way when you open it in an earlier version of Microsoft Excel.
In this article
Issues that cause a significant loss of functionality
| Issue | Solution |
| Any effects on this object will be removed. Any text that overflows the boundaries of this graphic will appear clipped. | What it means In Excel 2007 and later, you can use special effects, such as transparent shadows that are not supported in Excel 97-2003. The special effects will be removed. Also, in Excel 2007 and later, when you insert text in a shape that is wider than the shape, the text displays across the boundaries of the shape. In Excel 97-2003, this text is truncated. To avoid truncated text, you can adjust the size of the shape for a better fit. What to do In the Compatibility Checker, click Find to locate the objects that have special effects applied so that you can remove those effects as needed. |
| This object will no longer be editable. | What it means Embedded objects that are created in Excel 2007 and later cannot be edited in Excel 97-2003. What to do In the Compatibility Checker, click Find to locate the objects that contain text that will not be editable, and then make the necessary changes. |
| Uninitialized ActiveX controls cannot be transferred to the selected file format. The controls will be lost if you continue. | What it means If a workbook contains ActiveX controls that are considered to be Unsafe for Initialization (UFI), they are lost when you save the workbook to an earlier Excel file format. You may want to mark those controls as Safe for Initialization (SFI). What to do If you open a workbook that contains uninitialized ActiveX controls, and the workbook is set to high security, you must first use the Message Bar to enable them before they can be initialized. |
| One or more objects in this workbook (such as shapes, WordArt, or text boxes) may allow text to overflow the object boundaries. Earlier versions of Excel do not recognize this option and will hide overflowing text. | What it means In Excel 2010 and later, you can display text boxes on objects (such as shapes) and display the text beyond the boundaries of those objects. In Excel 97-2007, text that overflows the boundaries of an object will not be visible. What to do In the Compatibility Checker, click Find to locate the text box that contains text that overflows the boundaries of the shape, make the necessary changes to keep the text within the boundaries, and then turn the option to overflow text off (right-click the shape or text box, click Format Shape, click the Text Options category, click the Textbox button, and then select the Allow text to overflow shape check box). |
Issues that cause a minor loss of fidelity
| Issue | Solution |
| This workbook contains text boxes with text formatting not available in earlier versions of Excel. The text in the text boxes will appear differently in the earlier versions of Excel. | What it means In Excel 2007 and later, you can use a text box on objects (such as shapes) that displays more than one column of text. In Excel 97-2003, the text will be displayed but in a different format. What to do In the Compatibility Checker, click Find to locate the text box that displays more than one columns of text, and then make the necessary changes to display the text in one column only (right-click the shape, click Format Shape, click the Text Options category, click the Textbox button, and then click the Columns button). |
COMMENTS