Microsoft KB Archive/191123

= XL98: Linked References Not Updated in Closed Worksheet =

Article ID: 191123

Article Last Modified on 9/11/2002

-

APPLIES TO


 * 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.

