Keeping Options and Customization

[Erin Dicks]

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.

 

[Gord Dibben]

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