Microsoft Knowledge Base

XL: GP Fault Defining Local Name When "!" in Sheet Name
Last reviewed: March 26, 1997
Article ID: Q119823
5.00 5.00c 7.00 7.00a | 5.00 5.00a WINDOWS | MACINTOSH kbprb

The information in this article applies to:

  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

In the versions of Microsoft Excel mentioned above, if you attempt to define a local name on a sheet whose name contains an exclamation point (!), you may receive a general protection (GP) fault.

If you are using Microsoft Excel for the Macintosh, a type 1 (bus) error will occur.

WORKAROUND

To prevent this GP fault from occurring, use the OK button rather than the Add button in the Define Name dialog box when you initially define the name.

Selecting the Add button will not cause the GP Fault to occur if the name already exists. However, the name will appear incorrectly in the list of workbook names for as long as the Define Name dialog box is displayed on the screen.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Local names in Microsoft Excel version 5.0 use the following syntax: 

   <Sheet name>!<Name component>
For example, a local name defined on a sheet called "Sales" might look like this: 

   Sales!QuarterlyResults
If the sheet name itself contains an exclamation point (for example, if the sheet's name is "Hello!There"), a local name defined on that sheet might look like this: 

   Hello!There!Friend
Attempting to define a name with such an appearance will cause a GP Fault if you use the Add button in the Define Name dialog box when you initially define the name.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 5.00a 5.00c 7.00 7.00a GPF
Keywords : kbusage
Version : 5.00 5.00c 7.00 7.00a | 5.00 5.0
Platform : MACINTOSH WINDOWS

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: March 26, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.