Article ID: 157499
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q157499
SYMPTOMS
When you link a picture in a worksheet to a cell, the picture may not be immediately updated when you change the cell.
CAUSE
This problem may occur after you apply a conditional format to the cell to which your picture is linked.
NOTE: The same problem may happen if you already applied a conditional format to the cell, and you then link a picture and change the conditional format.
RESOLUTION
To resolve this problem, press F9 to recalculate the worksheet.
If you do not want to recalculate the entire worksheet, do the following:
- Select the cell to which your picture is linked.
- Click Bold on the formatting toolbar.
- If you do not want to apply the Bold format to the cell, click Bold once more.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
REFERENCES
For more information about conditional formatting, click the Index tab in Microsoft Excel Help, type the following text
conditional formats
and then double-click the selected text to go to the "Highlight data that meets conditions you specify" topic.
Additional query words: XL98
Keywords: KB157499