Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Excel configuration

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cmar - 07 Nov 2006 15:41 GMT
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
Bernard Liengme - 07 Nov 2006 15:57 GMT
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
Gord Dibben - 07 Nov 2006 16:31 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.