Microsoft KB Archive/178863

= XL98: Crash When Chart Gallery File Is Password Protected =

Article ID: 178863

Article Last Modified on 1/28/2005

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q178863



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

The application "Microsoft Excel" has unexpectedly quit, because an error of type 2 occurred.

You should save your work in other open applications and restart the computer.

-or-

Sorry, a system error occurred.

"Microsoft Excel"

error type 11



CAUSE
This problem occurs when either of the following conditions is true:
 * The Excel Chart Gallery(8) file is password protected. -or-


 * The Excel Chart User Gallery file is password protected.



WORKAROUND
To resolve this problem, remove the password protection from the Excel Chart Gallery(8) or the Xlusrgal.xls file. To do this, follow these steps:
 * 1) Open the appropriate file (Excel Chart Gallery(8) or Excel Chart User Gallery). By default, the files are stored in the System Folder:Preferences folder.

NOTE: The Excel Chart Gallery(8) and Excel Chart User Gallery files are chart "autoformat" files. These files store custom chart formats.
 * 1) On the File menu, click Save As, and then click Options.
 * 2) In the Password To Open box, click the password.
 * 3) Press DEL and Click OK.
 * 4) 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 Excel Chart User Gallery file, you lose any custom chart formats that you created.

If you delete the Excel Chart Gallery(8) file, you can recreate the file only by using the following steps:
 * 1) Double-click the Microsoft Office First Run file located in the Microsoft Office 98:Office folder.
 * 2) In the first dialog box that appears, click Install.



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
Excel Chart Gallery(8) stores custom chart formats that come with Microsoft Excel 98. Excel Chart User Gallery stores any custom chart formats that you create. Microsoft Excel does not create Excel Chart User Gallery 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:

178864 MacXL: Setting Default and User-Defined Chart Types

