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.

Kevin wrote:

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

--

Dave Peterson

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
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.

Kevin wrote:

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

--

Dave Peterson