Is there a way to port your quick access toolbar in excel

K

Kevin

I need to reinstall excel 2007 but was wondering if there is a way to save my
customized quick access tool bar before I do this. similar to the way you
could save your custom tool bars in Excel 2003
 
D

Dave Peterson

From what I've read, there's a file called *.QAT.

I'd use windows search to find and save a copy--make a note of the location,
too!

But in earlier versions of excel, reinstalling excel won't damage the .xlb
file. I wonder if the QAT is safe from reinstalls, too?

Maybe you could find it and back it up, but see if you need copy it back to the
original location.

Please post back with your findings.
 
R

Ron de Bruin

Hi Dave and Kevin

Excel saves your QAT setup in a file named "Excel.qat" in:
C:\Documents and Settings\<username>\Local Settings\Application Data\Microsoft\OFFICE\Excel.qat

In Vista you can find it here
C:\Users\<username>\AppData\Local\Microsoft\Office\Excel.qat

Note: This file will not exist if you have not customized your QAT

See also
http://www.rondebruin.nl/imageqat.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top