Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Multiple workbooks with links to the same source update each other

View products that this article applies to.


If you open multiple Excel workbooks that all contain links to the same source workbook, and you choose not to update the links, the links in all of the workbooks will be updated to the values that are stored in the last workbook that was opened.

↑ Back to the top


This behavior occurs because link information is stored in an internal link table. This link table is shared among all open workbooks in that instance of Excel. The most recently opened workbook provides the link table that is in memory at any specific time.

↑ Back to the top


To work around to this behavior, open the workbooks in different instances of Excel. As a result, each workbook maintains its own internal link table and stored values.

↑ Back to the top

Keywords: KB312188, kbprb

↑ Back to the top

Article Info
Article ID : 312188
Revision : 3
Created on : 7/31/2013
Published on : 7/31/2013
Exists online : False
Views : 370