XL98: Linked References Not Updated in Closed Worksheet

• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In Microsoft Excel 98 Macintosh Edition, if you move cells on a source worksheet, the original linked cell values on the dependent worksheet may no longer be referenced.

CAUSE

When you move linked cells in a source worksheet while the dependent worksheet is closed, the references in the dependent worksheet are not adjusted.

WORKAROUND

To work around this behavior, do either of the following:

• Make sure the dependent worksheet is open when you move linked cells on the source worksheet.


-or-


• Use named references when you link cells between worksheets. For example, use the following formula

  =[Workbook1]Sheet1!Test

  where Test is a defined name that refers to cell A1 in Sheet1.

STATUS

This is by design of Microsoft Excel 98 Macintosh Edition.

REFERENCES

For more information about Cell Links, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

linking data, external

Additional query words: XL98

Keywords : kbdta xlformula
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb