Article ID: 125183 - View products that this article applies to.
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
If the Microsoft Excel toolbar file becomes damaged, or is deleted or moved from its original location, Microsoft Excel may exhibit the following behavior:
This behavior occurs because the following items are stored in the Microsoft Excel toolbar file:
When you close Microsoft Excel, if the toolbar file is not located in its installed location, the file is created with the default information, and any new toolbar customization, custom list, and TipWizard history information.
Microsoft Excel 97 for WindowsIn Microsoft Excel 97 for Windows, the toolbar file is stored in your Windows folder and is named:
Microsoft Excel for Windows 95, version 7.0In Microsoft Excel for Windows 95 version 7.0, the toolbar file is named username.xlb and is stored in the Windows folder. For example, if your username 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.0In Microsoft Excel version 5.0, the toolbar file is named Excel5.xlb, and is stored in the Windows folder.
Microsoft Excel for the Macintosh, version 5.0In Microsoft Excel for the Macintosh, version 5.0, the toolbar file is named Excel Toolbars (5), and is stored in the Preferences folder.
For more information about saving custom toolbars, choose the Search button in Help and type:
toolbarsFor more information about entering a custom Autofill list on a worksheet, choose the Search button in Help and type:
custom listsFor more information about using the TipWizard, choose the Search button in Help and type: