Microsoft KB Archive/119713

{|
 * width="100%"|

XL5: GP Fault Showing Dependents/Precedents for Selected Cell

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0

-

SYMPTOMS
In Microsoft Excel, when you locate a precedent or dependent cell for a cell that contains an external reference to a defined name, you receive a general protection (GP) fault.

CAUSE
This problem occurs when the defined name refers to a complex expression, and the complex expression evaluates to a cell reference. The following are examples of complex expressions that evaluate to cell references on a worksheet:

=Sheet1!A1,Sheet1!A2

=Sheet1!$A$1:INDEX(data,2,3) This problem does not occur if the defined name refers to a complex expression that evaluates to a value, for example =SUM($A$1,$A$3).

Note that this behavior only occurs if the cell that you find precedents or dependents for contains an external reference to the defined name, such as =BOOK1!Test. The behavior occurs whether you use the Go To Special dialog box, or the key combinations CTRL+SHIFT+{, CTRL+[, CTRL+SHIFT+} or CTRL+], to locate any precedent or dependent cells.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in a later version of Microsoft Excel.