Tuesday, December 12, 2017

Graphics, object, or ActiveX control compatibility issues in Excel 2016 for Windows

Graphics, object, or ActiveX control compatibility issues in Excel 2016 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

Issues that cause a minor loss of fidelity

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).

Top of Page

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).

Top of Page

No comments:

Post a Comment