Microsoft KB Archive/291074

From BetaArchive Wiki
Knowledge Base


Default toolbars and toolbar buttons seen instead of customizations in Excel

Article ID: 291074

Article Last Modified on 1/31/2007



APPLIES TO

  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition



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.

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



Additional query words: prb XL2002

Keywords: kbprb KB291074