XL2000: #REF! Error Recalculating Worksheet with Defined Name (221058)
The information in this article applies to:
This article was previously published under Q221058 SYMPTOMS
When your worksheet is recalculated, some cells may display the #REF! error code.
CAUSE
This problem may occur if the following conditions are true:
- The cells that contain the #REF! error code refer to a defined name.
-and-
- The defined name refers to an external file.
-and-
- The defined name contains a relative cell reference to a cell in the external file.
RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).
To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:
245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)
To temporarily work around this problem, type the reference to the external file in the cell, rather than using a defined name to refer to the external file.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.
Modification Type: | Major | Last Reviewed: | 11/5/2003 |
---|
Keywords: | kbbug kbpending KB221058 |
---|
|