Microsoft Office Tutorials and References
In Depth Information
The XLB File
This file is updated whenever a change is made to the Quick Access toolbar or to the Ribbon. It’s
updated immediately, not when Excel is closed. This file doesn’t exist unless you’ve made at least
one change to the user interface.
You can view Excel.officeUI using an XML editor, a Web browser, or Excel. To view this file
in Excel, follow these steps:
Make a copy of the Excel.officeUI file.
Add an XML extension to the copy of the file so that the name is Excel.officeUI.XML .
Choose File➜Open to open the file or just drag it into Excel’s window.
You’ll see a dialog box with some options; choose As an XML Table.
Figure 4-8 shows an imported Excel.officeUI file (the file is displayed as a table). In this
case, the Quick Access toolbar has two commands enabled (rows 12 and 13 in the table), and I
added a new tab and group, with two commands (rows 14 and 15 in the table).
It’s possible to share an Excel.officeUI file with other users. For example, you may have
customized your Quick Access toolbar with some handy tools, and added a new Ribbon tab with lots
of useful commands, nicely organized . If a colleague is impressed, just give him a copy of your
Excel.officeUI file and tell him where to put it. Keep in mind that replacing an existing
Excel.officeUI file will overwrite any changes your colleague has made.
Don’t attempt to modify the Excel.officeUI file unless you know what you’re doing. But feel
free to experiment. If Excel reports an error in the Excel.officeUI file at start-up, you can just
delete the file, and Excel will create a new one. Better yet, keep a backup copy of the original.
Figure 4-8: Viewing an Excel.officeUI data file in Excel.
The XLB File
Excel stores customized toolbar and menu bar configurations in an XLB file. Even though Excel
2010 doesn’t officially support custom toolbars and menus in the way that it did in previous
versions, it still uses an XLB file if you use any applications that create toolbars or custom menus. If you
can’t find an XLB file, it means that Excel isn’t storing any custom toolbar or menu configurations.