??? about restoring a "customized version" of Excel 2002 !

[Kipp Park]

Help !!!

I just got done rebuilding a friend's Windows XP
Professional desktop. I installed his MSOffice for XP,
and installed using the recommended installation
procedure. Now, when he launches Excel, it doesn't have
his "customized layout" and "other handy functions" that
he added into his original Excel program way back when. I
do, however, still have his original harddrive which
contains my friend's "customized version of Excel 2002"
and was wondering is there a "folder, folders, or files" I
need to copy into his hew installation of MSOffice for XP,
which, in this case, I more concerned about RESTORING his
original customized version of Excel than anything else ?

Mr. Park

 

[Gord Dibben]

Kipp

NOTE: some settings are workbook-specific and would be stored with the
workbook.

For other global stored settings..........

Do a file search for *.XLB which is the file that Excel stores some
preferences in(some are written to the registry, see below).

Menu and Toolbar customizations are saved in the *.XLB file.


A file search may turn up more than one *.XLB file. You will have
to determine which is correct one.

Note where they are and make a minor change to a Toolbar in Excel.
Save/close and see which *.XLB file was modified.

You can copy this file and save as a backup

If changing versions of Excel at the same time, you will find that
the *.XLB names are different. Make the appropriate name changes
and place in the proper folder.

xl97 is username8.xlb
xl2000 is excel.xlb.
xl2002 is excel10.xlb

Screen layout, color info, checked Add-ins and many Tools>Options
settings are stored in the Registry, not in the *.XLB file.

To see some of what's stored in the Registry have a peek at this
section in it, if you feel comfortable.

HKEY_CURRENT_USER\Software\Microsoft\Office\XX.0\Excel\Options

XX is your version of Excel...8,9,10,11

Assuming you are aware of the precautions taken when editing the
Registry and know how to restore a recent backup of same.......

If not, maybe have a look here first...scroll down to "Registry
editing tips"

http://www.activewin.com/tips/reg/index.shtml

Export all these keys(as a branch group) to a .REG file so's you can
back them up.

Note also: you may want to move over your *.ACL(autocorrect files) and any
*.DIC files.

For a more comprehensive listing see Dave Peterson's posting at

http://snipurl.com/8r7x

Gord Dibben Excel MVP

 

[Guest]

Gord,

Thanks for your input...I'll try your suggestions this
upcoming week and see if they're helpful in resolving my
problem. Appreciate your response !!!

Kipp

-----Original Message-----
Kipp

NOTE: some settings are workbook-specific and would be stored with the
workbook.

For other global stored settings..........

Do a file search for *.XLB which is the file that Excel stores some
preferences in(some are written to the registry, see below).

Menu and Toolbar customizations are saved in the *.XLB file.


A file search may turn up more than one *.XLB file. You will have
to determine which is correct one.

Note where they are and make a minor change to a Toolbar in Excel.
Save/close and see which *.XLB file was modified.

You can copy this file and save as a backup

If changing versions of Excel at the same time, you will find that
the *.XLB names are different. Make the appropriate name changes
and place in the proper folder.

xl97 is username8.xlb
xl2000 is excel.xlb.
xl2002 is excel10.xlb

Screen layout, color info, checked Add-ins and many Tools>Options
settings are stored in the Registry, not in the *.XLB file.

To see some of what's stored in the Registry have a peek at this
section in it, if you feel comfortable.

HKEY_CURRENT_USER\Software\Microsoft\Office\XX.0 \Excel\Options

XX is your version of Excel...8,9,10,11

Assuming you are aware of the precautions taken when editing the
Registry and know how to restore a recent backup of same.......

If not, maybe have a look here first...scroll down to "Registry
editing tips"

http://www.activewin.com/tips/reg/index.shtml

Export all these keys(as a branch group) to a .REG file so's you can
back them up.

Note also: you may want to move over your *.ACL (autocorrect files) and any
*.DIC files.

For a more comprehensive listing see Dave Peterson's posting at

http://snipurl.com/8r7x

Gord Dibben Excel MVP