XL97: Attached Toolbar Is Not Saved in 5.0/95 File Format (157027)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q157027

SYMPTOMS

In Microsoft Excel 97, when you save a workbook, a custom toolbar that is attached to the workbook may not be saved.

CAUSE

This behavior occurs when you save the workbook in the "Microsoft Excel 5.0/95 Workbook(*.xls)" file format.

NOTE: If you save the workbook in the "Microsoft Excel Workbook(*.xls)" file format, an attached toolbar is saved with the workbook.

STATUS

This is by design of Microsoft Excel 97.

MORE INFORMATION

In Microsoft Excel 97, you can attach custom toolbars to workbooks. If a workbook contains an attached toolbar, the toolbar is available to every user who opens the workbook.

To attach a custom toolbar to a workbook, use the following steps:
  1. On the View menu, point to Toolbars, and click Customize.
  2. Click Attach.
  3. In the list of Custom Toolbars, select a toolbar that you want to attach to the active workbook, and click Copy. Repeat this step for each toolbar you want to attach to the workbook.
  4. Click OK, and then click Close.

REFERENCES

For more information about attaching toolbars to workbooks, click the Index tab in Microsoft Excel 97 Help, type the following text 
   toolbars, workbooks
and then double-click the selected text to go to the "Attach a custom toolbar to a workbook" topic.
Modification Type:MajorLast Reviewed:10/21/2000
Keywords:kbprb KB157027
©2002 Microsoft Corporation. All rights reserved.