Copy Office 2007 and 2010 Quick Access Toolbars
After customizing a Quick Access Toolbar, you can quickly copy it to other computers. You can add your favourite commands or even missing commands to the QAT for quick access. All of the Office applications support a QAT.
If you have or support more than one system, you don’t have to duplicate your efforts where QATs are concerned. Instead, customize one and copy it to other computers. Just be careful because Office 2007 QAT files aren’t compatible with Office 2010 QAT files.
Office 2007
Each application has its own QAT file, as listed in the following table. When copying Outlook files, be sure to select the right one (or all of them) as your copy of Outlook might have several .qat files.
Program |
Feature area |
File name |
Access 2007 |
Access.qat |
|
Excel 2007 |
Excel.qat |
|
Outlook 2007 |
Contacts |
Olkaddritem.qat |
Calendar |
Olkapptitem.qat |
|
Distribution list |
Olkdistitem.qat |
|
Journal entry |
Olklogitem.qat |
|
|
Olkmailitem.qat |
|
Post in folder |
Olkpostitem.qat |
|
Tasks |
Olktaskitem.qat |
|
PowerPoint 2007 |
PowerPoint.qat |
|
Word 2007 |
Word.qat |
Office saves the .qat files in different locations, depending on your operating system.
NOTE: to find these file locations make sure in the Folder Option, under View, you have selected to show hidden files, folders, and drives and unselected Hide extensions for Known file types.
· Windows XP usually saves .qat files in the following folder:
o C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Office
· If you’re running Windows Vista and Windows 7, they’re most likely in this folder:
o C:\Users\username\AppData\Local\Microsoft\Office
Run a Windows Search to find the files if your system is configured differently. After locating the .qat file, copy it to another computer. Be sure to note the actual location in your source computer and copy the file to the same location on the target computer.
Office 2010
Of course, it’s different for Office 2010. In this version, the .qat files are now .officeUI files.
· In Windows XP, look for these files in the following folder:
o C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Office
· In Vista and Windows 7 systems, look for these files in this folder:
o C:\Users\username\AppData\Local\Microsoft\Office
Upgrading from 2007 to 2010
If you’re upgrading to 2010 from 2007 and you’re supporting several systems:
1. Save the .qat files to disc or someplace safe so they’re not destroyed during the installation of Office 2010.
2. After installing Office 2010, give the new .officeUI files a new extension name, such as .officeUIorg, so you can recognize them later. You want to keep them around, just in case.
3. Then, copy the 2007 .qat files in to the above folder location and rename it to use the .officeUI extension to the appropriate folder in Office 2010.
I repeat, do not write over the .officeUI files. Rename them, so you can retain those files in installation order.
Thanks to: Susan Harkins
http://www.techrepublic.com/blog/msoffice/copy-office-2007-and-2010-quick-access-toolbars/4253
Leave a Reply!