View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Keeping Options and Customization

Erin

Customizes Toolbars and Menu setting are store in Excelxx.xlb file where xx
isyour version of Excel.

Usually found in C:\Documents and Settings\username\Application
Data\Microsoft\Excel

There are other files you may want to transfer.

Here is a list from Dave Peterson...............

I have a short list of things to copy/update when we change pc's at work.

It's not complete, but may help you.

Word/Excel files:

FileName Use
custom.dic personal dictionary
*.acl personal autocorrect list
mssp2_en.exc personal exclusion dictionary
normal.dot default (for new documents) template
*.dot Any other templates you've made

*.xlb personal toolbar
book.xlt defaults for new workbooks
sheet.xlt defaults for new worksheets
personal.xl* personal macros
*.xlt Any other templates you've made



Gord Dibben MS Excel MVP

On Fri, 16 Jan 2009 11:24:00 -0800, Erin Dicks
wrote:

Is there a file I can copy that would allow me to keep the
options/customization I've set up with Excel if it is reinstalled? My
employer regularly 'refreshes' our desktops and I lose a lot of what I've set
up, such as a custom toolbar with custom buttons, and my many adjusted
settings under options. I keep a copy of personal.xls so at least I don't
lose my macros, but is there another file I can copy to keep more of my
customization?

Thanks.