Bear
With Excel there is no one file such a s Normal.dot that can be transferred.
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.
Before reading further.......
Transferring your *.xlb file from 97 to 2003 will reduce the functionality
of new version menu items, although most of them can be dragged onto the old
menu.
Read on.........
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 ToolsOptions
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\E xcel\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
On Wed, 25 Oct 2006 20:34:02 -0700, bear wrote:
I'm getting moved around at work to new computer i get to use a few weeks or
so at a time. instead of resetting up word and excel, so i can use it
effectively, every time i get moved to a new computer, i'm looking for a fast
way to do it. The normal.dot file allows me to do that with word and i'm
looking for a similar fix for excel. Is there a way or am I sol? Thanks
very much for the assistance.
"Jim Thomlinson" wrote:
The Normal.dot is the template file that Word uses as the basis to create
Word documents. Any modifications to it change the way that all subsequently
created documents will perform and react. Excel is quite different. There is
no template. The application level settings are stored in the operating
systems registry. So there is no file that you can go to. What are you
wanting to do or see?
--
HTH...
Jim Thomlinson
"bear" wrote:
Where and\or what is the name of the file that stores the global excel
settings?
The global settings file in Word is the Normal.dot file and is in this path
C:\Documents and Settings\bear\Application Data\Microsoft\normal.dot
Gord Dibben MS Excel MVP