XL97: Crash When Chart Gallery File Is Password Protected

Last reviewed: January 15, 1998
Article ID: Q161438
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

When you click Chart Type on the Chart menu, and then click the Custom Types tab, you may receive the following error message:

   This program has performed an illegal operation and will be shut down.
   If the problem persists, contact the program vendor.

If you click Details, a message similar to the following appears:

   EXCEL caused an invalid page fault in module EXCEL.EXE at
   0137:300af7a2.

CAUSE

This problem occurs when either of the following conditions is true:

  • The Xl8galry.xls file is password protected.

        -or-
    
  • The Xlusrgal.xls file is password protected.

RESOLUTION

To resolve this problem, follow these steps to remove the password protection from the Xl8galry.xls or the Xlusrgal.xls file:

  1. Open the appropriate file (Xl8galry.xls or Xlusrgal.xls).

    By default, the files are stored in the Program Files\Microsoft Office\Office folder.

    NOTE: The Xl8galry.xls and Xlusrgal.xls files are chart "autoformat" files. These files store custom chart formats.

  2. On the File menu, click Save As, and then click Options.

  3. In the Password To Open box, click the password.

  4. Press DELETE, and then Click OK.

  5. Click Save, and then click Yes when you are prompted to overwrite the existing copy of the file.

If you do not know the password, you must delete the chart autoformat file that is password protected.

If you delete the Xlusrgal.xls file, you lose any custom chart formats that you created.

If you delete the Xl8galry.xls file, you can recreate the file only by using the following steps:

  1. Start the Microsoft Office Setup program.

    Because you already installed Microsoft Office, the Setup program runs in maintenance mode.

  2. In the first dialog box that appears, click Reinstall.

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

Xl8galry.xls stores custom chart formats that come with Microsoft Excel 97. Xlusrgal.xls stores any custom chart formats that you create. Microsoft Excel does not create Xlusrgal.xls until you create a custom chart format.

For additional information about working with custom chart types in Microsoft Excel, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q161348
   TITLE     : XL97: Working With Default and User Defined Chart Formats

REFERENCES

For more information about Chart Autoformats, click the Index tab in Microsoft Excel Help, type the following text

   chart creation, templates

and then double-click the selected text to go to the "Save a custom chart type to apply to other charts" topic.


Additional query words: XL97
Keywords : xlchart xlgpf kberrmsg kbualink97
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug
Solution Type : kbworkaround


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: January 15, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.