Solved

2010 excel QAT backup

Posted on 2011-03-04
7
558 Views
Last Modified: 2012-05-11
how can i backup/export my customized QAT [quick access toolbar]?
where are the settings stored?
0
Comment
Question by:alk444
  • 4
  • 2
7 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35037941
Search for Excel.qat on your C drive (location will vary by OS)
0
 

Author Comment

by:alk444
ID: 35038089
no joy. file does not exist.

win7pro64
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35038103
You need to ensure you search in hidden and system folders.
On my machine (XP) it is:
C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\OFFICE
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:alk444
ID: 35038210
i do not have any files or extensions hidden.

what is the file name in your installation?

i did find C:\Users\Owner\AppData\Local\Microsoft\Office\Excel.officeUI
which might be it, but how would i make excel pick it up for another user?
0
 

Accepted Solution

by:
alk444 earned 0 total points
ID: 35038869
C:\Users\Owner\AppData\Local\Microsoft\Office\Excel.officeUI is it. by further experimentation i found that it can be exported [and imported] from the QAT customization form.
0
 
LVL 14

Expert Comment

by:Zack Barresse
ID: 35044877
FYI, if you are exporting the file (right click QAT, Customize QAT, Import/Export) it can be saved anywhere you like.  I'm assuming that's what you meant by your last post.  It saves all your UI changes, including your Ribbon customizations.  It is the same for all 2010 Office applications, where the default name changes from Excel Customizations, or Word Customizations, etc.

HTH
0
 

Author Closing Comment

by:alk444
ID: 35081181
i found it myself.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

828 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