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:
- 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:
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:
- Open or create a chart that contains the formatting you want to add as a
custom chart format.
- From the Tools menu, choose Options, and select the Chart tab.
- 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
|