YourComputerGuru.com.au

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
	Mail	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