Microsoft KB Archive/105944: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - """ to """)
 
Line 90: Line 90:
== REFERENCES ==
== REFERENCES ==


&quot;User's Guide,&quot; version 5.0, pages 161-170<br />
"User's Guide," version 5.0, pages 161-170<br />
<br />
<br />
For more information about linking in Microsoft Excel 97, click '''Contents and Index''' on the '''Help''' menu, click the '''Index''' tab in Excel Help, type the following text<br />
For more information about linking in Microsoft Excel 97, click '''Contents and Index''' on the '''Help''' menu, click the '''Index''' tab in Excel Help, type the following text<br />
Line 100: Line 100:


</div>
</div>
and then double-click the selected text to go to the '''&quot;creating links&quot;''' topic. If you are unable to find the information you need, ask the Office Assistant.<br />
and 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.<br />





Latest revision as of 09:10, 20 July 2020

Knowledge Base


Article ID: 105944

Article Last Modified on 8/15/2003



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q105944

SYMPTOMS

In Microsoft Excel, 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, use either of the following methods:

  • 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

    =[Book1.xls]Sheet1!Test

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


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.

However, Microsoft Excel versions 5.0 and later track cell movement and adjust references to external documents only when the dependent worksheet is open. If the dependent worksheet is closed and you move cells on the source worksheet, the changes are not reflected when you open the dependent worksheet. In later versions of Microsoft Excel, worksheets that contain links take less room on your hard disk and are saved more quickly than linked worksheets in earlier versions of Microsoft Excel.

REFERENCES

"User's Guide," version 5.0, pages 161-170

For more information about linking in Microsoft Excel 97, click Contents and Index on the Help menu, click the Index tab in Excel Help, type the following text

links, creating


and 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 XL

Keywords: kbprb KB105944