The Excel 97 custom toolbars are not available in Excel 2000 (228667)


The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Excel 97 for Windows
This article was previously published under Q228667
For a Microsoft Excel 2002 version of this article, see 280641.

SYMPTOMS

When you upgrade from Microsoft Excel 97 to Excel 2000, your custom toolbars and toolbar customizations are no longer available.

CAUSE

This problem occurs when the following conditions are true:
  • You have custom toolbars or toolbar customizations in Microsoft Excel 97.

    -and-

  • You upgrade to Microsoft Excel 2000.

RESOLUTION

To migrate the custom toolbars from Microsoft Excel 97 to Microsoft Excel 2000, manually open the toolbar file (*.xlb) which contains the customization information. To do this, follow these steps:
  1. Start Microsoft Excel.
  2. On the File menu, click Open.
  3. In the Look in list, click the system drive (usually lettered C:) and double-click the folder where Microsoft Windows is installed (usually the Windows folder).
  4. Depending on which file is available, select one of the following files and click Open:

    Excel8.xlb

    -or-

    username8.xlb

    where username is your logon name.

  5. Click Open. Microsoft Excel will merge the custom toolbars and toolbar customizations with the current toolbars.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MinorLast Reviewed:12/2/2004
Keywords:kbbug kbpending KB228667
©2004 Microsoft Corporation. All rights reserved.