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?

"havocdragon" wrote:

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?

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 ToolsOptions
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\E xcel\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

On Mon, 16 Oct 2006 16:24:01 -0700, havocdragon
wrote:

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?

"havocdragon" wrote:

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?

Gord Dibben MS Excel MVP

Thanks Gord that helped greatly!!

"Gord Dibben" wrote:

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 ToolsOptions
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\E xcel\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

On Mon, 16 Oct 2006 16:24:01 -0700, havocdragon
wrote:

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?

"havocdragon" wrote:

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?

Gord Dibben MS Excel MVP