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

  • Thread starter Thread starter Kevin
  • Start date Start date
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
 
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.
 
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
 
Back
Top