Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel global settings file
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel global settings file
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel global settings file
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel global settings file
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Worksheet Functions | |||
Reflecting info between an excel file and a word one or two excel file. | Links and Linking in Excel | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |