XL5: GP Fault Showing Dependents/Precedents for Selected Cell

 Last reviewed: September 12, 1996
Article ID: Q119713
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.

REFERENCES

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

    dependents

KBCategory: kbother
KBSubcategory:

Additional reference words: 5.00 gpf



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.