Microsoft KB Archive/111491

= XL5GALRY.XLS Opened As Hidden Workbook =

Article ID: 111491

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0c
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q111491



SUMMARY
In Microsoft Excel, the file XL5GALRY.XLS is opened as a hidden workbook when you do any of the following:
 * Create a chart with a user-defined chart set as the Default Chart Format
 * Apply a user-defined chart autoformat using the AutoFormat command located on the Format menu
 * Choose Options from the Tools menu

Note that when you perform one of the above actions for the first time, it takes longer than when you perform the action again in the same session of Microsoft Excel. This additional time is the time it takes Microsoft Excel to open the file XL5GALRY.XLS. You cannot unhide this file when it is open.



MORE INFORMATION
When you perform one of the above actions, the XL5GALRY.XLS file is opened as a hidden file, and remains in your computer's memory until you do any of the following:
 * Quit Microsoft Excel
 * Close all files by holding down the SHIFT key and choosing Close All from the File menu.
 * Open the file XL5GALRY.XLS. (This action is not recommended.)

The file XL5GALRY.XLS is used to store custom chart autoformats. This file is in the Microsoft Excel version 5.0 file format (with slight modifications so that it can be accessed as a hidden workbook). To modify this file, use one of the methods below.

CAUTION: You should not have to open this file to modify it. If you do open XL5GALRY.XLS, you should create a backup before making any changes to the file.

Using the AutoFormat Command
Add a custom chart format to XL5GALRY.XLS or delete a custom chart format from XL5GALRY.XLS by doing the following:

 Open or create a chart that contains the formatting you want to add as a custom chart format. From the Format menu, choose AutoFormat. Under Formats Used, select the User-Defined option, and choose Customize.

To add a custom chart format:

 Choose Add. In the Format Name box, type the name for your custom autoformat. In the Description box, type a description for your custom autoformat. Choose OK. Choose Close.

To delete a custom chart format:

 From the Formats list, select the autoformat you want to remove. Choose Delete. Choose Yes to delete the user-defined format. Choose Close.</li></ol> </li></ol>

Using Chart Tab in Options Dialog Box
Add a custom chart format to XL5GALRY.XLS by doing the following:


 * 1) Open or create a chart that contains the formatting you want to add as a custom chart format.
 * 2) From the Tools menu, choose Options, and select the Chart tab.
 * 3) Choose the Use The Current Chart button. In the Format Name box, type the name for your custom autoformat and choose OK.

The new chart autoformat you created is added to the Default Chart Format list and is selected as the default. If you don't want this format to be applied to all new charts, select another autoformat from the Default Chart Format list. Choose OK.

<div class="references_section">