How Do I Copy Customized QAT from Desktop to Laptop?

T

Terry

I customized the quick access toolbar in Excel 2007 on my desktop (running
Win XP), adding a number of buttons to it, and want to copy the settings to
Excel 2007 on my laptop (Win 7). I located the Excel.qat file on my desktop
and copied it both to [UserName]/AppData/Roaming/Microsoft/Excel and to
..../Microsoft/Office on the laptop. However, when I open Excel on the laptop,
the default minimal quick access bar appears. How can I get the desktop qat
into laptop Excel?

Thank you,
Terry
 
R

Ron de Bruin

Hi Terry

Copy it here

C:\Users\<username>\AppData\Local\Microsoft\Office\Excel.qat

on my machine it is
C:\Users\Ron Desktop\AppData\Local\Microsoft\Office
 

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

Similar Threads

How do I create Personal.xlsb 6
copy buttons from one qat to another 2
Word 2007 copy normal.dotm and word.qat to laptop 3
Run a macro from another workbook in the QAT 1
copy quick access toolbar 1
Assign buttons on QAT 3
QAT Queries 4
make QAT inaccesible 1

Top