XL: XL5GALRY.XLS Opened As Hidden Workbook

ID: Q111491

5.00 5.00c 7.00 WINDOWS kbusage

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for Windows NT, version 5.0
Microsoft Excel for Windows 95, version 7.0

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:

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:

   a. Choose Add.

   b. 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:

   a. From the Formats list, select the autoformat you want to remove.

   b. 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.

REFERENCES

For an Overview Of Working With Chart Autoformats, choose the Search button in Help and type:

    chart autoformats

KBCategory: kbusage KBSubcategory:

Additional reference words: 7.00 5.00

Version           : 5.00 5.00c 7.00
Platform          : WINDOWS

Last Reviewed: November 17, 1998