XL98: Linked References Not Updated in Closed Worksheet (191123)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
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
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
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.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbprb KB191123 |
|---|
|