Microsoft KB Archive/228667

= The Excel 97 custom toolbars are not available in Excel 2000 =

Article ID: 228667

Article Last Modified on 12/2/2004

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



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:  Start Microsoft Excel. On the File menu, click Open. 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). Depending on which file is available, select one of the following files and click Open:

Excel8.xlb

-or-

8.xlb

where  is your logon name.

 Click Open. Microsoft Excel will merge the custom toolbars and toolbar customizations with the current toolbars.</ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2000 tool bar commandbar command

Keywords: kbbug kbpending KB228667

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.