Microsoft KB Archive/157499

= XL97: Picture Linked to Cell Does Not Immediately Update =

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:


 * 1) Select the cell to which your picture is linked.
 * 2) Click Bold on the formatting toolbar.
 * 3) 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.

