The information in this article applies to:
SYMPTOMS
In Microsoft Excel versions 5.0, 5.0c, and 7.0, when you open a workbook
that contains a drawing object, the following problems may occur:
CAUSEThis behavior may occur when you create the drawing object or AutoShape in Microsoft Excel 97 and then open the workbook in an earlier version of Microsoft Excel. The drawing system in Microsoft Excel 97 includes new features that do not translate correctly to earlier versions of Microsoft Excel. WORKAROUND
To work around this behavior, use the Copy Picture command to convert
AutoShapes and drawing objects to pictures before you save the workbook in
the Microsoft Excel 5.0/95 format. To convert an object or an AutoShape
into a picture, use the following steps:
NOTE: When you use this method, you can no longer format the converted object as an AutoShape or drawing object. MORE INFORMATIONWhen you open a workbook in Microsoft Excel 5.0, 5.0c or 7.0, drawing objects that you create in Microsoft Excel 97 may appear incorrectly, either on the screen or in the Format dialog box. The following sections discuss the symptoms in more detail. Drawing Object Is Rotated IncorrectlyWhen you create a rotated drawing object or AutoShape in Microsoft Excel 97, and you open the workbook in earlier versions of Microsoft Excel, the rotation may be lost or changed.Gradient Fill Pattern Appears IncorrectlyWhen you create a drawing object or AutoShape with a gradient fill pattern in Microsoft Excel 97, and you open the workbook in earlier versions of Microsoft Excel, the pattern may be replaced with a solid color that is the wrong color. Also, the Format dialog box may display the wrong sample color.Texture Fill Pattern Disappears CompletelyWhen you create a drawing object or AutoShape with a textured fill pattern in Microsoft Excel 97, and you open the workbook in earlier versions of Microsoft Excel, the texture is replaced by a solid color. The color of the fill pattern becomes "average" color of the texture that is replaced.Picture Fill Pattern Disappears CompletelyWhen you create a drawing object or AutoShape with a picture as the fill pattern in Microsoft Excel 97, and you open the workbook in earlier versions of Microsoft Excel, the drawing object appears completely transparent. You can see cells "through" the drawing object.Additional query words: 5.00c 7.00a XL97 8.0 XL98
Keywords : xlloadsave xldraw |
Last Reviewed: October 25, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |