The only user interface element in Excel 2007 that's customizable by the end user is the Quick Access Toolbar. The information for the QAT is stored in a file named Excel.qat, and this file is located here:
C:\Documents and Settings\ <username> \Local Settings\Application Data\ Microsoft\OFFICE
This file is updated whenever a change is made to the QAT. It's updated immediately, not when Excel is closed.
Excel.qat is an XML file, and you can view it using an XML editor, a Web browser, or Excel. To view this file in Excel, follow these steps:
Make a copy of the Excel.qat file.
Add an XML extension to the copy of the file so that the name is Excel.qat.xml .
Choose Office 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.qat file (the file is displayed as a table). This QAT has three commands in addition to the eleven default commands. Of the default commands, only three are visible.
It's possible to share a QAT with other users. For example, you may have customized your QAT with two dozen useful tools. If a colleague is impressed, just give him a copy of your Excel.qat file and tell him where to put it.
Don't attempt to modify the Excel.qat file unless you know what you're doing.