Excel Personal settings/macros

B

Bill

I am using Excel 2003. I just ordered a new computer and would like to be
able to transfer the file/s that contain my personal settings(toolbar set
ups for example)/macros/whatever else to the new machine. Is this possible?
What files do I need to copy and transfer and where do I find them.

Please don't tell me I can't do this. <G>

TIA

Bill
 
D

Dave Peterson

Saved from a previous post:

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

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

Bill

Thanks Dave - I am going to be using the same version of Office I have now -
Office 2003


Saved from a previous post:

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

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

Max

Suggest that Dave's very useful "survival" list
be "bookmarked" in perhaps, Debra's site <g> ?
 
H

Harlan Grove

Dave Peterson wrote...
....
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

And don't forget any:
Local files (If you don't store on LAN)
(Settings) Directories and other defaults (Tools|Options stuff) ....
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.
....

Someday in the distant future, Microsoft may learn the fundamentals of
sensible file system organization, and some years after that may
actually implement it in Office.

Linux/Unix/BSD systems can be run from CDs or other read-only media as
long as there are read-write media for a swap partition, temporary
files and user files. Only sysadmins can modify system-level
configuration. Any & all user-level configuration is stored in the
user's home directory. Save the user's home directory between updates,
and the user keeps his/her configuration after updating. It's difficult
to grasp just how badly Windows and Office are organized until you see
how easy it is to upgrade other operating systems in which *ALL* user
files are stored on different disk partitions than OS and third party
program files.

The Windows equivalent would be that users other than Administrator and
not in the Administrators group couldn't make ANY changes in any
directory on their C: drives other than in %USERPROFILE%, %HOME%,
%TEMP% and %ALLUSERSPROFILE%\Shared Documents (the last being an overly
long counterpart to Linux/Unix/BSD /pub directories). Only sysadmins
should put anything in %PROGRAMFILES% or %SYSTEMROOT%. Letting any user
modify anything in C:\Program Files\Microsoft Office\Office is begging
for trouble.

That said, everyone should maintain a batch file for storing
configuration data. Multiple XCOPY commands work pretty well, as would
a commandline Zip file program. IMO, this is one thing for which GUI
tools are vastly inferior.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top