XL2000: Picture Linked to Cell Is Not Immediately Updated (211996)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q211996

SYMPTOMS

When you link a picture in a worksheet to a cell in Microsoft Excel 2000, the picture may not be immediately updated when you change the cell.

CAUSE

This behavior can occur after you apply a conditional format to the cell to which your picture is linked, or if you have already applied a conditional format to the cell and you then link a picture and change the conditional format.

RESOLUTION

To work around this issue, press F9 to recalculate the worksheet.

If you do not want to recalculate the entire worksheet, follow these steps:
  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 again.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

REFERENCES

For more information about conditional formatting, click Microsoft Excel Help on the Help menu, type about highlighting cells that meet specific conditions in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbbug kbpending KB211996
©2003 Microsoft Corporation. All rights reserved.