• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 526
  • Last Modified:

Where do the QAT files reside in Office 2010?

Hello,

Up until today, I have been using Office 2007 but I just installed Office 2010.  Unfortunately however, I forgot to pinpoint exactly where the QAT files were located or even take a screenshot of my long-standing 2007 QAT before upgrading.

Now with Office 2010 installed, the QAT's are missing when I open Excel or Word.  I was looking around through the folders and found what I think are my current QAT files -- at least that's the case judging by when they were last modified.  Here's the directory path and a screenshot:

C:\Users\Steve\AppData\Local\Microsoft\Office
 1I've got some notes from when I first installed Office 2007 that the QAT files can simply be copy/pasted to the new folder.  However, I cannot find anything saying where that folder is located for 2010.

So that is my question:  Where do the QAT files reside in Office 2010?

Thanks

PS   Wow, I just noticed that the big Office button located in the upper left corner in Office 2007 is gone.  Is it supposed to be that way?

0
Steve_Brady
Asked:
Steve_Brady
  • 2
1 Solution
 
Steve_BradyAuthor Commented:
Perfect!  That is just what I needed.

Just change the extension from .QAT to .officeUI.

Here it is from your link:

"...the *.qat files need to be renamed to *.officeUI and placed in one of the following folders:
  In Windows 7 or Vista - C:\Users\%username%\AppData\Local\Microsoft\Office
           or
  In Windows XP - C:\Documents and Settings\%username%\Local Settings\Application Data\Microsoft\Office (in Windows XP)."
0
 
Steve_BradyAuthor Commented:
Thanks!
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello Steve,

I realise that this question is closed, but I'm not writing to provide an answer. Just some chat.

Congratulations on leaving 2007 behind. Welcome to 2010.

I hated 2007 from day 1 and have tried to duck it wherever I could.

From the day I installed the 2010 beta, though,  almost 2 years ago, I loved it.

I guess in the mean time, I had gotten used to the ribbon concept, and, of course, a lot of 2007 bugs and annoyances have been fixed in 2010.

Be glad that the Office Globe has disappeared. The File tab, which opens the Back Stage View, will not take you long to get used to, and the whole package makes a lot more sense, I feel.

Also, enjoy the fact that the Excel macro recorder now records (most, not all) code that deals with charts and objects, which makes life a lot easier for us noobs trying to figure out the object models for simple stuff.

I'll note that you're on 2010, and from now on will take that into account when responding to your questions.

The learning curve for 2010 is not steep when you come from 2007. If you also know 2003, then you will see some previously familiar functionality re-instated that was dropped for 2007 (for example: use F4 to repeat the last action when formatting chart elements. Worked fine in 2003, but not in 2007 :-(  , but 2010 has that functionality back).

Don't hesitate to ask if you're stuck or things look unfamiliar. I'll  be keeping an eye out for your questions.

cheers, teylyn
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now