Solved

Where do the QAT files reside in Office 2010?

Posted on 2011-09-02
4
497 Views
Last Modified: 2012-05-12
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
Comment
Question by:Steve_Brady
  • 2
4 Comments
 
LVL 23

Accepted Solution

by:
Michael74 earned 500 total points
ID: 36476656
0
 

Author Comment

by:Steve_Brady
ID: 36476758
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
 

Author Comment

by:Steve_Brady
ID: 36476759
Thanks!
0
 
LVL 50

Expert Comment

by:teylyn
ID: 36477519
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

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now