Article ID: 110006 - View products that this article applies to.
This article was previously published under Q110006
When you open a workbook in Microsoft Excel 2000, in Microsoft Excel 2002, or in Microsoft Office Excel 2003, the Update Remote References calculation setting for the workbook is usually selected. The exception to this rule occurs when a workbook has been linked to an external data source, and when you do not allow Excel to update links to the external data source.
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure. However, they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.
The Update Remote References calculation setting determines whether Excel updates formulas that include references to external data sources, such as Microsoft Word for Windows documents or Microsoft Access databases.
Note Excel workbooks and documents are not external data sources.
When you open a workbook, the Update Remote References setting is set according to the following table.
To clear the Update Remote References setting in the active workbook, follow these steps:
Collapse this tableExpand this table
Sample Visual Basic procedureThe following Visual Basic code example assumes that you have a file that is called TEST.XLS that is located in the C:\EXCEL directory. The example opens the TEST.XLS file and then clears (turns off) the Update Remote References check box. As the Sub procedure opens the file, it also prevents Excel from updating any of the workbook's external or remote references.
Note The Update Remote References check box is not a universal setting. When two workbooks are open, one workbook might have its Update Remote References setting selected whereas the check box is cleared in the other workbook. However, when you open a workbook, its Update Remote References check box will be selected, no matter how it was saved, unless it contains links to an external data source.
Article ID: 110006 - Last Review: June 4, 2007 - Revision: 3.0