Moving PREFERENCES from an old computer to new

G

Gareth Minor

I am currently in the process of moving to a new laptop.

Instead of setting up all my old preferences again, I
believe I can just move preferences files from my old
computer to the new computer. I cannot however find out
how to do this.

Can anyone help?

Many thanks,
Gareth.
 
G

Gord Dibben

Gareth

I assume you are referring to preferences with Excel.

Do a file search for *.XLB which is the file that Excel stores most
preferences in(some are written to the registry).

Menu and Toolbar customizations are saved in the *.XLB file.

A file search may turn up more than one *.XLB file. You will have to
determine which is correct one.

Note where they are and make a minor change to a Toolbar in Excel. Save/close
and see which *.XLB file was modified.

You can copy this file over to the new Computer.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 

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