Written by Allen Wyatt (last updated July 13, 2024)
This tip applies to Excel 97, 2000, 2002, and 2003
Excel, like all Office Applications, is highly customizable. This means that you can change menus, toolbars, and other user interface options quite easily. (In fact, you can make Excel look completely different if you want to.)
As you make changes to your toolbars, Excel keeps track of the changes in a special file that has the extension .xlb. Depending on your version of Excel and the operating system you are using, the file could be called Excel.xlb, Excel10.xlb, Excel11.xlb, or even yourname.xlb (where yourname is your system login name).
The contents of the .xlb file are updated whenever you quit your Excel session. It is interesting to note that this particular filename extension is only used by Excel for this one file. This means that it is very easy to locate the file using the Find File feature of Windows, and then copy the file to a safe location. (The file can be in different locations, depending on your Excel version and your operating system version.)
It is a good practice to periodically make backups of the .xlb file and store them in a safe place. If, at some later time, your toolbars become corrupted in Excel, you can quit the program and copy the backup version of your .xlb file over the top of the corrupted file. This should then restore everything to the proper state when you again start Excel.
As a side note, if you wanted to get rid of all your customizations at once, you could simply rename or delete the .xlb file. The next time you restart Excel, it recreates the file for you using default settings.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2068) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!
Do you wish that the buttons on your Excel toolbars were easier to see and use? The answer could be to turn on the large ...
Discover MoreDon't like the toolbar button images in your version of Excel? Don't fret; you can pull up the button editor and make ...
Discover MoreWant to get rid of a toolbar button? There's no need to drag open the menus and dialog boxes; just use the shortcut ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
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 © 2024 Sharon Parq Associates, Inc.
Comments