Copy quick access bar to another PC?

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

Does anyone know if there is any way to copy a customised quick access
bar between PCs and installations of Excel?

I'd like to use my bar from work at home without needing to re-create it.

Many thanks....Jason

---
 
Thanks Ron. Which part of the article ? Is it the Copy a customized QAT
from one workbook to another(Add-in)? (or is this just to copy it to a
workbook as I want to copy it to my home copy of excel and for it to be
available in *all* workbooks).

Thanks for your help,

Jason
 
Ignore my last post Ron. I've found the path:

C:\Documents and Settings\<username>\Local Settings\Application
Data\Microsoft\OFFICE\Excel.qat

That's great. I can just copy it for my home PC

Thanks again.... Good tips on the site as well!

Jason
 
It is in the first part
"How do you customize the QAT for all workbooks"

Excel saves your QAT setup in a file named "Excel.qat" and in Win XP you will find it here :
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


--

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