Microsoft KB Archive/817038

= When you update a link in an Excel workbook, the link in a second workbook updates =

Article ID: 817038

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



SYMPTOMS
When you use two workbooks that reference the same source cells in a source workbook you may find that when the source workbook is updated, both workbooks reflect the update. This issue occurs even when the update is applied to only one of the workbooks.



CAUSE
This issue may occur if all the following conditions are true:


 * Two different workbooks reference the same source location.


 * Both workbooks are open in the same session.


 * The source workbook is updated and the updates are applied and saved to one of the workbooks.

This issue occurs because Microsoft Excel maintains an internal table of cell values for linked cells. Although each workbook has its own table, only one copy of the table is maintained in an Excel session.



WORKAROUND
To work around this issue, do not open multiple workbooks that reference the same source during the same Excel session.

Additional query words: xl2007 xl2003 xl2002 xl2000 xl97

Keywords: kbprb KB817038

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.