Default toolbars and toolbar buttons seen instead of customizations in Excel

Article translations Article translations
Article ID: 291074 - View products that this article applies to.
This article was previously published under Q291074
For a Microsoft Excel 98 version of this article, see 192217.

For a Microsoft Excel 97 and earlier version of this article, see 125183.
Expand all | Collapse all

SYMPTOMS

If the Microsoft Excel toolbar file becomes damaged, or is deleted or moved from its original location, you may see the following behavior:
  • Toolbars and toolbar buttons that you created no longer appear.
  • Changes that you made to toolbars and toolbar buttons no longer appear.
  • The default toolbars and toolbar buttons appear.
Note The file name of the Microsoft Excel toolbar file differs for different version of Excel. In Excel 2000, the file name is Excel.xlb. In Excel 2002, the file name is Excel10.xlb. In Excel 2003, the file name is Excel11.xlb.

CAUSE

This behavior occurs if the custom toolbar file is damaged or missing.

Excel stores information about custom toolbars in the Excel toolbar file. If the toolbar file is not located in its installed location when you close Microsoft Excel, Excel creates the file with the default information or any new customizations you made while Excel was running.

MORE INFORMATION

If you are using Microsoft Windows 98 or Microsoft Windows Millennium Edition (Me) in the default configuration (without User Profiles enabled), the Excel10.xlb file is stored in the following folder:
c:\Windows\Application Data\Microsoft\Excel
If you are using Microsoft Windows NT, the Excel10.xlb file is stored in the following folder:
c:\Winnt\profiles\username\Application Data\Microsoft\Excel
If you are using Microsoft Windows 2000 or Microsoft Windows XP, the Excel10.xlb file is stored in a folder similar to the following:
C:\Documents and Settings\username\Application Data\Microsoft\Excel
Note Microsoft Office 2003 products can only be installed on the following operating systems:
  • Microsoft Windows 2000 Service Pack 3 (SP3)
  • Microsoft Windows XP
  • Microsoft Windows Server 2003
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
125183 Default toolbars and toolbar buttons seen instead of customizations

Properties

Article ID: 291074 - Last Review: January 31, 2007 - Revision: 2.4
APPLIES TO
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbprb KB291074

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com