Microsoft KB Archive/280641

= The Excel 97 custom toolbars are not imported when you upgrade from Excel 97 to a later version of Excel =

Article ID: 280641

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q280641





For a Microsoft Excel 2000 version of this article, see 228667.



SYMPTOMS
When you upgrade Microsoft Excel 97 to a later version of Microsoft Excel, custom Excel 97 toolbars are no longer visible.



CAUSE
This behavior occurs because later versions of Excel do not automatically migrate custom toolbars.



WORKAROUND
To work around this issue, open your Excel 97 custom toolbar in the later version of Excel. To do this, follow these steps.

In Microsoft Windows 98

 * 1) Click Start, point to Find, and then click Files or Folders.
 * 2) On the Name & Location tab, in the Named box, type *8.xlb.
 * 3) In the Look in list, click My Computer.
 * 4) Click to select the Include subfolders check box, and then click Find Now.

Notice that 8.xlb appears.
 * 1) Double-click  8.xlb.

In Microsoft Windows 2000 or in Microsoft Windows Millennium Edition (Me)

 * 1) Click Start, point to Search, and then click For Files or Folders.

Notice that the Search Results dialog box appears.
 * 1) In the Search for files or folders named box, type *8.xlb.
 * 2) In the Look in list, click My Computer, and then click Search Now.

Notice that 8.xlb appears in the name list of the Search Results pane.
 * 1) Double-click  8.xlb.

Notice that Excel 2002 starts and your Excel 97 custom toolbar is visible.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
Custom toolbars that you create in Excel 97 are saved in the 8.xlb file, where   is the name of the person to whom Excel is licensed.

To view this information, follow these steps:
 * 1) Start Excel.
 * 2) On the Help menu, click About Microsoft Excel.

Notice that the licensee is displayed in the This product is licensed to box.

NOTE: If the computer is used by multiple users, you may find more than one custom XLB file. Choose the appropriate one based on your user name.

Additional query words: XL2002 XL2003 XL2007

Keywords: kbbug kbpending KB280641

-

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

© Microsoft Corporation. All rights reserved.