QAT

[dasadler]

When moving from one machine to another. Is there any way to copy/move any heavily customized QATs?

[HansV]

Customizations to the Quick Access Toolbar are stored in .qat files in C:\Users\<username>\AppData\Local\Microsoft\Office (Windows Vista or newer) or C:\Documents and Settings\<username>\Application Data\Microsoft Office (Windows XP).

x1402.png

Remember, AppData is a hidden folder, so you must display hidden files and folders in order to see it.
You can copy the .qat files from the old computer to the appropriate folder on the new one.

[stuck]

NB .qat files are used by Office 2007. I discovered recently when the first Office 2010 PC arrived in our office that it uses a different file format and possibly a different location.

Ken

[HansV]

I have Office 2010, but I see that the files in my screenshot haven't been updated for almost 2 years. That would agree with them being from Office 2007. I have a newer bunch of files with extension .officeUI and .customUI.

[stuck]

Yes, I discovered about the change that Office 2010 introduced when I tried to deploy our std .qat files and they didn't show up in Word or Excel.

Fortunately our QATs are not that complex so it only took a couple of mins to recreate them. Note to self must remember that I've yet to take a copy of these new files off that PC.

Ken

[dasadler]

Thanks for the info - good to be able to move them instead of recreating them.