XL5: GP Fault Showing Dependents/Precedents for Selected Cell

ID: Q119713

5.00 WINDOWS kbother

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

Version           : 5.00
Platform          : WINDOWS

Last Reviewed: September 14, 1996