Default Toolbars and Toolbar Buttons Seen Instead of Customizations

This article was previously published under Q125183
This article has been archived. It is offered "as is" and will no longer be updated.
For a Microsoft Excel 2002 version of this article, see 291074.
For a Microsoft Excel 98 version of this article, see 192217.
Symptoms
If the Microsoft Excel toolbar file becomes damaged, or is deleted ormoved from its original location, Microsoft Excel may exhibit thefollowing behavior:
  • Toolbars and toolbar buttons created no longer appear.
  • Changes that you have made to toolbars and toolbar buttons no longer appear.
  • Custom lists that you have created or imported using the Custom Lists tab in the Options dialog box are missing.
  • If you previously had the TipWizard displayed, it is no longer displayed. When you display the TipWizard, the tip is the introductory greeting that was displayed after you first installed Microsoft Excel.
Cause
This behavior occurs because the following items are stored in theMicrosoft Excel toolbar file:
  • Toolbar customization and layout
  • Menu bar customization and layout (Microsoft Excel 97 only)
  • Custom AutoFill lists
  • TipWizard history
If this file is missing or damaged, Microsoft Excel uses the defaultinformation for these items; default toolbars and toolbar buttons, defaultcustom AutoFill lists, and default TipWizard history information.

When you close Microsoft Excel, if the toolbar file is not located in itsinstalled location, the file is created with the default information, andany new toolbar customization, custom list, and TipWizard historyinformation.
More information

Microsoft Excel 97 for Windows

In Microsoft Excel 97 for Windows, the toolbar file is stored in yourWindows folder and is named:
  • Excel8.xlb, if your computer is not connected to a network or is not set up with a logon prompt.

    -or-
  • Username8.xlb, where Username is your user logon name.

Microsoft Excel for Windows 95, version 7.0

In Microsoft Excel for Windows 95 version 7.0, the toolbar file is namedusername.xlb and is stored in the Windows folder. For example, if yourusername is suejones, then the toolbar file will be named Suejones.xlb.

NOTE: If you click Cancel in the Windows login dialog box, to cancel your connection to your network, Microsoft Excel version 7.0 will not use the username.xlb file; instead it will use the Excel5.xlb file in the Windows folder. If Microsoft Excel version 7.0 cannot locate a file called Excel5.xlb, it creates one in the Windows folder.

Microsoft Excel for Windows, version 5.0

In Microsoft Excel version 5.0, the toolbar file is named Excel5.xlb, andis stored in the Windows folder.

Microsoft Excel for the Macintosh, version 5.0

In Microsoft Excel for the Macintosh, version 5.0, the toolbar file isnamed Excel Toolbars (5), and is stored in the Preferences folder.
References
For more information about saving custom toolbars, choose the Searchbutton in Help and type:
toolbars
For more information about entering a custom Autofill list on a worksheet,choose the Search button in Help and type:
custom lists
For more information about using the TipWizard, choose the Searchbutton in Help and type:
TipWizard
5.00c 97 XL
Properties

Article ID: 125183 - Last Review: 10/26/2013 12:21:00 - Revision: 2.0

  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • kbnosurvey kbarchive kbinfo KB125183
Feedback