Knowledge Base

XL98: Linked References Not Updated in Closed Worksheet

Article ID: 191123

Article Last Modified on 9/11/2002

Microsoft Excel 98 for Macintosh

This article was previously published under Q191123

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

and then click Show Topics. Select the "Create a formula to calculate data on another worksheet or workbook" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: XL98

Keywords: kbprb KB191123