Article ID: 158156
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q158156
SYMPTOMS
When you create a drawing object in Microsoft Excel 97, if you apply a shadow to the drawing object, the shadow may appear differently than in earlier versions of Microsoft Excel.
CAUSE
This will occur if all the following conditions are true:
- The drawing object was created in Microsoft Excel 97. -and-
- The drawing object is not filled (it is transparent). -and-
- The workbook containing the drawing object has not been saved, or has been saved in the Microsoft Excel 97 format, closed and reopened.
WORKAROUND
If you create a drawing object in Microsoft Excel 97 and it needs to have a solid shadow, you must apply a fill to the drawing object. Use the following steps to do this:
- Select the drawing object.
- On the Format menu, click AutoShape.
- Click the Colors and Lines tab.
- In the Fill drop-down list box in the Color section, click a color, or click Fill Effects and select a fill effect.
- Click OK.
The shadow will now appear solid.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
MORE INFORMATION
In Microsoft Excel, drawing objects that you create can be filled or unfilled. Filled objects are opaque; unfilled objects are transparent, and you can see cells or other objects through them.
In Microsoft Excel 97, when you create a drawing object, such as a rectangle, and then apply a shadow to the object, the shadow may not appear solid, but as a line. This will occur if the drawing object is not filled (it is transparent).
Shadows applied to drawing objects should appear correctly if any of the following conditions are true:
- The drawing object was created in an earlier version of Microsoft Excel. -or-
- The drawing object is filled. -or-
- The workbook that contains the drawing object is not saved in the Microsoft Excel 97 format.
Additional query words: XL98
Keywords: kbualink97 kbprb KB158156
