I have Office 2003 on two systems, one of them brand new. Is there a way to
move my Excel configuration from the old to the new system?
Thanks, CMA
In the folder C:\Documents and Settings\Owner\Application
Data\Microsoft\Excel
I have a file called Excel11.xlb (for my Excel 2003 version)
I could also have a file called Book.XLT
These hold the configurations I have for Excel.
If I copy these to my other PC then both Excel apps will be similarly
configured.
best wishes

Signature
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
>I have Office 2003 on two systems, one of them brand new. Is there a way to
>move my Excel configuration from the old to the new system?
> Thanks, CMA
Toolbar and Menu customizations are stored in your xxxxxx.XLB file where
xxxxxx is version-dependent name.
Excel 97.....username.xlb
Excel 2000...Excel9.xlb
Excel 2002...Excel10.xlb
Excel 2003...Excel11.xlb
Note: there may be other customizations you want to transfer at the same time.
NOTE: some settings are workbook-specific and would be stored with the
workbook.
For other global stored settings..........
Screen layout, color info, checked Add-ins and many Tools>Options
settings are stored in the Registry, not in the *.XLB file.
To see some of what's stored in the Registry have a peek at this
section in it, if you feel comfortable.
HKEY_CURRENT_USER\Software\Microsoft\Office\XX.0\Excel\Options
XX is your version of Excel...8,9,10,11
Assuming you are aware of the precautions taken when editing the
Registry and know how to restore a recent backup of same.......
If not, maybe have a look here first...scroll down to "Registry
editing tips"
http://www.activewin.com/tips/reg/index.shtml
Export all these keys(as a branch group) to a .REG file so's you can
back them up.
Note also: you may want to move over your *.ACL(autocorrect files) and any
*.DIC files.
For a more comprehensive listing see Dave Peterson's posting at
http://snipurl.com/8r7x
Gord Dibben Excel MVP
>I have Office 2003 on two systems, one of them brand new. Is there a way to
>move my Excel configuration from the old to the new system?
> Thanks, CMA
Gord Dibben MS Excel MVP
cmar - 07 Nov 2006 20:56 GMT
Thanks to Bernard an Gord. It seems that the safe procedure would be to just
copy Excel11.xlb
CMA
> Toolbar and Menu customizations are stored in your xxxxxx.XLB file where
> xxxxxx is version-dependent name.
[quoted text clipped - 52 lines]
>
> Gord Dibben MS Excel MVP