Microsoft KB Archive Search

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.

  1. Home
  2. XL2000: Linked Cells Display #REF! Error Message with Dependent Workbook

XL2000: Linked Cells Display #REF! Error Message with Dependent Workbook

View products that this article applies to.

This article was previously published under Q214023

↑ Back to the top

Symptoms

In Microsoft Excel, if you open a dependent document linked to a source document, you may receive the following error message:
#REF!

↑ Back to the top

Cause

This behavior occurs when the source document is renamed after the link to it is created in the dependent document.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

More information

This behavior is not the same as in the earlier versions of Excel; in versions earlier than Excel 5.0, a Change Links dialog box is displayed regardless of which document is opened first. Excel versions 5.0 and later view worksheets as documents within a workbook and do not display an alert message when a worksheet is not found.

↑ Back to the top

Keywords: KB214023, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 214023
Revision : 4
Created on : 9/27/2003
Published on : 9/27/2003
Exists online : False
Views : 255