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

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

Back to the top

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

Back to the top

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.

Back to the top

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

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

Back to the top

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