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.
|