The information in this article applies to:
SYMPTOMSIn Microsoft Excel, if you move cells on a source worksheet, the original linked cell values on the dependent worksheet may no longer be referenced. CAUSEWhen 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, use either of the following methods:
MORE INFORMATION
In Microsoft Excel versions 3.0 and 4.0, if both the source and dependent files are open when you create the links, the links between worksheets are adjusted when you move cells on the source worksheet. This behavior occurs both when the dependent worksheet is open and when it is closed. REFERENCES
"User's Guide," version 5.0, pages 161-170 links, creatingand then double-click the selected text to go to the "creating links" topic. If you are unable to find the information you need, ask the Office Assistant. Additional query words: XL97 link linking update
Keywords : kbdta xlformula |
Last Reviewed: June 10, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |