XL5: GP Fault Showing Dependents/Precedents for Selected Cell

The information in this article applies to:

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.


REFERENCES

For more information about Finding Cells With Formulas That Refer To Selected Cells (Dependents), choose the Search button in Help and type:

dependents

Additional query words: gpf

Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :
Technology :


Last Reviewed: September 21, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.