Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Where do the QAT files reside in Office 2010?

Posted on 2011-09-02
4
Medium Priority
?
519 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 23

Accepted Solution

by:
Michael Fowler earned 2000 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
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

636 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