Microsoft KB Archive/108358

From BetaArchive Wiki
Knowledge Base


Errors If XL5GALRY.XLS Is Saved with Password

Article ID: 108358

Article Last Modified on 8/15/2003



APPLIES TO

  • Microsoft Excel 5.0c
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 5.0a for Macintosh



This article was previously published under Q108358

SUMMARY

In the versions of Microsoft Excel listed above, if you open the XL5GALRY.XLS file, which is located in your EXCEL\XLSTART directory, and then save it with a password, you may be prompted to enter a password whenever you attempt to perform certain actions.

It is recommended that you DO NOT save the XL5GALRY.XLS file with any kind of password.

MORE INFORMATION

Microsoft Excel saves user-defined autoformats and other chart information in the XL5GALRY.XLS file, located in the EXCEL\XLSTART directory. This file is modified through choices that you make in various dialog boxes in Microsoft Excel.

If you open XL5GALRY.XLS and then save it with a password, you may notice the following unexpected behavior when you are working in Microsoft Excel, version 5.0:

  • If you click Options on the Tools menu, you may be prompted to enter a password. If you enter the correct password, the Options dialog box will appear and you should have full access to all options. If you do not enter a password, you will receive the error message

    Error accessing User-defined AutoFormat file

    and the Options dialog box will appear. However, you will not be able to change the Default Chart Format setting on the Chart tab.
  • If you click AutoFormat on the Format menu when a chart is active, selecting the User-Defined option may result in a prompt for a password. If you enter the correct password, you should be able to make any desired changes to the User-Defined options.

    If you do not enter a password, you may receive the error message

    Error accessing User-defined AutoFormat file

    and you may not be able to access or define custom formats, depending on the type of password which has been set.

For the above reasons, and because there may be other negative effects associated with a password-protected XL5GALRY.XLS file, it is recommended that you DO NOT save the XL5GALRY.XLS file with any kind of password.



Additional query words: 5.00a 5.00c XL

Keywords: kberrmsg kbinfo KB108358