Software

Copy Office 2007 and 2010 Quick Access Toolbars

After customizing a Quick Access Toolbar, you can quickly copy it to other computers, if you know where to find the files!

Office 2007's answer to all those missing menu commands from earlier versions is the Quick Access Toolbar (QAT). You can add your favorite 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. Just for the record, Windows XP usually saves .qat files in the following folder:

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:

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

Files come and go so quickly here!

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:

C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Office

In Vista and Windows 7 systems, look for these files in this folder:

C:\Users\username\AppData\Local\Microsoft\Office

Upgrading?

If you're upgrading to 2010 from 2007 and you're supporting several systems, you probably have access to migration tools that will convert existing .qat files to .officeUI files. If you don't have access to such a neat tool, save the .qat files to disc or someplace safe so they're not destroyed during the installation of Office 2010. 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. Then, copy the 2007 .qat files using 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.

About Susan Harkins

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks

Free Newsletters, In your Inbox