XL5GALRY.XLS Opened As Hidden Workbook

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:

1. Open or create a chart that contains the formatting you want to add as a custom chart format.
2. From the Format menu, choose AutoFormat. Under Formats Used, select the User-Defined option, and choose Customize.
   
   To add a custom chart format:
   
   
   1. Choose Add.
   2. 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:
   
   
   1. From the Formats list, select the autoformat you want to remove.
   2. Choose Delete. Choose Yes to delete the user-defined format. Choose Close.

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.