The information in this article applies to:
SYMPTOMSIn Microsoft Excel version 5.0, if you open a Microsoft Excel version 4.0 chart file, and the chart has a reference that contains the INDIRECT() function in a defined name, you receive a general protection (GP) fault if you evaluate the reference in the formula bar. CAUSE
When you open a Microsoft Excel version 4.0 file that contains a defined
name, the name is defined as a global name, rather than a local name. If
the name contains the INDIRECT() function, and the reference in the
function does not contain the worksheet name, the INDIRECT() function
evaluates the reference on the current sheet. Note that this same error message appears if you create a chart in Microsoft Excel version 5.0, and then reference a defined name that contains the INDIRECT() function. If you evaluate the reference to the defined name that contains the INDIRECT() function on the chart sheet, by selecting the reference, and pressing F9, you receive a GP fault. WORKAROUNDSTo avoid receiving a GP fault when you evaluate a reference to a defined name that contains the INDIRECT() formula, include the sheet name in the INDIRECT() function. For example, use
instead of:
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. REFERENCESFor more information about INDIRECT, choose the Search button in Help and type: INDIRECT function Additional query words: gpf
Keywords : |
Last Reviewed: September 15, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |