reinstall

[Sue Sweet]

I am going to have uninstall office to correct the error of installing office
service pack 3. I know how to save my Normal template from MSWord so that I
keep all my autotext etc.
My questions is how do I do that in Excel? I have several macros and custom
toolbars that I don't want to have to redo.
Is there a file that I can save like the MSWord template?

Thanks

Sue

 

[Peo Sjoblom]

I believe I snipped this from Dave Peterson one time or another

"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

And don't forget any:
Local files (If you don't store on LAN)
(Settings) Directories and other defaults (Tools|Options stuff)

====

I've found the easiest way to find these files is to use Windows start
button|Search.

Remember to look through hidden folders/files. And if I find multiple files
of
the same name, I open excel (say), then make a minor change to that file.
Then
search again. Then I can pick out the current version of the file.

That said, if you're upgrading from an older version of office, I wouldn't
copy
the toolbar. (I would take good notes to help me rebuild this toolbar
(maybe
even fix it up a bit).)

Same with the normal.dot (I'd let MSWord rebuild that--then just copy|paste
any
macros into it manually.)

The *.xlt (book.xlt, sheet.xlt), I'd copy over, but then open and resave
them
using the newer version."

--


Regards,


Peo Sjoblom