Written by Allen Wyatt (last updated December 16, 2023)
This tip applies to Excel 97, 2000, 2002, and 2003
Gary wrote about a frustration he experienced with Excel. He had some macros, stored in his Personal.xls workbook, that were assigned to some custom toolbar buttons. Out of the blue, the macros disappeared, and Gary couldn't figure out why.
There are any number of reasons why this could happen, so it is very hard to narrow down to a definitive answer. There are a few things to check, however.
Toolbar customizations are stored in a file with an extension .XLB. The main portion of the file name varies based on your version of Excel and Windows. The name may be something like excel10.xlb or some name containing your user ID and a version number. It is usually on the C:\ drive and often in Windows folder or in a personal settings folder (on my system it is C:\Documents and Settings\Allen L. Wyatt\Application Data\Microsoft\Excel\Excel11.xlb.)
The XLB file may become corrupt for various reasons. Because of this, it is a good idea to make a backup of the file so that if it ever gets modified unintentionally or somehow gets corrupted, you can just delete the old one and rename the backup.
The XLB file can be "lost" in various ways. Most often it is due to sloppy programming. Some programmers may decide to make changes to the toolbars to add their own customizations, or they may decide to change the configuration of Excel's menus. All these changes get written to the XLB file, and this is not normally a problem. It can become a problem, however, if Excel ends abnormally and the programmer's code doesn't restore the toolbars or menus in the way it should.
Even if Excel doesn't exit abnormally, there could still be problems introduced by the programmer's code. Excel does not include a command to restore the toolbars to some saved configuration. Programmers often write code to check out the status of all the toolbars and then reverse the steps to get back to that condition, but if the code has errors in it, then the toolbars may be left in an unstable or (worse yet) unusable condition. This is bad.
The solution is to rely on your backup of the XLB file. You need to make sure that you save the file so that you can restore it if you detect a problem with the toolbars or menus. If you make any changes that you want to keep, make a new backup of the XLB file. This is nothing but cheap insurance.
Note:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2368) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Dive Deep into Macros! Make Excel do things you thought were impossible, discover techniques you won't find anywhere else, and create powerful automated reports. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable. You’ll find step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and solutions. Check out Microsoft Excel 2019 VBA and Macros today!
If you are using a mouse that has a center wheel, you can use the wheel to zoom in and out of your work. This tip shows ...
Discover MoreIf your worksheet gets large enough, you may notice a severe slowdown when it is recalculated. This tip provides some ...
Discover MoreIf you have some legacy data stored in very old spreadsheet files, you may be wondering how to get that data into an ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2026-04-25 13:08:26
John Mann
An alternative approach would be to create an export file of the Excel customiastions.. In my Excel 2010, there is an Export/Import at the bottom of the customise dialogue boxes for bothe the Ribbon and the QAT. After choosing export, this opens a Save As dialogue box which is pointing the the Excel's default save location (as set in Options) - in my case "C:\Data Files\Docs", with a defualt file name "ExcelCusgtomizastions.exportedUI". The only file type offered is ".exportedUI".
This would be the file to use when exporting settings to a new computer - but would just as well work when used for backup on the same computer.
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2026 Sharon Parq Associates, Inc.
Comments