Have to upgrade from office 2000 to 2003, need some help.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

So my work is upgrading from office 2000 to 2003, they have a page to upgrade
this and its not too difficult so I can live with that part.

The real question I have is...I have lots of persnal workbook macros,
functions...add ins etc etc. What all do I need to save to ensure all my user
settings will transition over to the new excel?
 
Nothin at all? Wow, my first dissappointment in this site in like 3 years ive
been using it =).

Theres gotta be a few things I need to save like, personal.xls and
atvbaen.XLA right?
 
You don't need to save any of the Excel default add-ins like atvbaen.xla

They will be installed with 2003 if you pick typical installation.

As far as everything else goes...................

Toolbar and Menu customizations are stored in your xxxxxx.XLB file where
xxxxxx is version-dependent name.

Excel 97.....username.xlb

Excel 2000...Excel9.xlb

Excel 2002...Excel10.xlb

Excel 2003...Excel11.xlb

Note: there may be other customizations you want to transfer at the same time.

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

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

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

Nothin at all? Wow, my first dissappointment in this site in like 3 years ive
been using it =).

Theres gotta be a few things I need to save like, personal.xls and
atvbaen.XLA right?
Click to expand...

Gord Dibben MS Excel MVP
 
Thanks Gord that helped greatly!!

Gord Dibben said:
You don't need to save any of the Excel default add-ins like atvbaen.xla

They will be installed with 2003 if you pick typical installation.

As far as everything else goes...................

Toolbar and Menu customizations are stored in your xxxxxx.XLB file where
xxxxxx is version-dependent name.

Excel 97.....username.xlb

Excel 2000...Excel9.xlb

Excel 2002...Excel10.xlb

Excel 2003...Excel11.xlb

Note: there may be other customizations you want to transfer at the same time.

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

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

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



Gord Dibben MS Excel MVP
Click to expand...
 
Back
Top