Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

This article was previously published under Q280641
For a Microsoft Excel 2000 version of this article, see 228667 (http://support.microsoft.com/kb/228667/ ) .
For a Microsoft Excel 2000 version of this article, see 228667 (http://support.microsoft.com/kb/228667/ ) .

↑ Back to the top


Symptoms

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

↑ Back to the top


Cause

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

↑ Back to the top


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 username8.xlb appears.
  5. Double-click username8.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.
  2. In the Search for files or folders named box, type *8.xlb.
  3. In the Look in list, click My Computer, and then click Search Now.

    Notice that username8.xlb appears in the name list of the Search Results pane.
  4. Double-click username8.xlb.
Notice that Excel 2002 starts and your Excel 97 custom toolbar is visible.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


More information

Custom toolbars that you create in Excel 97 are saved in the username8.xlb file, where username 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.

↑ Back to the top


Keywords: KB280641, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 280641
Revision : 4
Created on : 1/29/2007
Published on : 1/29/2007
Exists online : False
Views : 310