XL7: Links to Other Sheets in Workbook Not Recalculated

• Microsoft Excel for Windows 95, versions 7.0

SYMPTOMS

When you create a link from one sheet to the same cell or range in another sheet in a workbook, the link either is not updated automatically or it is updated inconsistently. For example, if you create the following link in cell P20 of Sheet 1

   =sheet2!P20

Similarly, if a range of cells refers to a cell or cells on another sheet, the cells may not all be updated correctly when cells on the original sheet are modified.

WORKAROUND

A patch is available that corrects this problem. In addition, Microsoft Office version 7.0b corrects the behavior. However, note that although the dependencies work correctly, affected cells that already contain incorrect values are not automatically updated. You must force existing incorrect values to recalculate, and then resave the file.

You can recalculate all cells in the workbook by pressing CRTL+ALT+F9. To save the file, click Save on the File menu. New values that you type into the affected cells will recalculate correctly.

NOTE: Pressing F9 to update the affected cells does not update the incorrect values.

For information about obtaining the patch, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q128650
   TITLE     : XL7 Patch Available: 15-Digit Number, Linking, and Transpose

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows 95, version 7.0a.

REFERENCES

For more information about updating calculations, click the Index tab in Help and type the following text

   calculating formulas