The Excel 97 custom toolbars are not imported when you upgrade from Excel 97 to Excel 2002 (280641)


The information in this article applies to:

  • Microsoft Excel 2002
  • Microsoft Excel 97 for Windows
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 Microsoft Excel 2002, custom Excel 97 toolbars are no longer visible.

CAUSE

This behavior occurs because Excel 2002 does not automatically migrate custom toolbars.

WORKAROUND

To work around this issue, open your Excel 97 custom toolbar in Excel 2002. To do so, 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 Windows 2000 or 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.

STATUS

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

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.

For more information about custom toolbars, click Microsoft Excel Help on the Help menu, type custom toolbars in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MinorLast Reviewed:12/2/2004
Keywords:kbbug kbpending KB280641
©2004 Microsoft Corporation. All rights reserved.