XL5: GP Fault Using Shared Formula as Computed Criteria

ID: Q118756

5.00 WINDOWS kbother fixlist5.00c

The information in this article applies to:

SYMPTOMS

In Microsoft Excel, when you filter a list using computed criteria, and the following conditions are true

you receive a general protection (GP) fault when the cell that the defined name refers to changes.

CAUSE

This error occurs when you change the value in the cell that the defined name refers to, when the defined name is used as a computed criteria on a worksheet other than the worksheet that contains the list. This problem occurs when you use the Advanced Filter feature to filter the list.

Note that if you use one of the database functions such as DCOUNT() under the above conditions, you may either receive a GP fault, or the value in the computed criteria may not change when you change the value in the cell that the defined name refers to.

WORKAROUNDS

To avoid receiving a GP fault when you use a computed criteria on one sheet, with a list on another worksheet, do any of the following:

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 Microsoft Excel for Windows version 5.0c.

REFERENCES

For more information about Setting Up A Criteria Range, choose the Search button in Help and type:

    computed criteria


KBCategory: kbother KBSubcategory:

Additional reference words: 5.00

Version           : 5.00
Platform          : WINDOWS

Last Reviewed: September 14, 1996