Transfer settings from Excel 2003 to Excel XP

**hershmab** · 12-28-2010, 11:46 AM

I have been running Excel 2003 on my old machine and need to transfer my settings (macros, toolbars, buttons, user-defined functions etc.) to Excel XP on a new Virtual XP machine.
The relevant files to transfer are, I think:

excel11.xlb
personal.xls
udf.xla (my own user-defined functions)

My questions are:

Is that the complete list, or are there any others I do not know about?
As the transfer is a downgrading from Office11 (2003) to Office10 (XP/2002), do I have to convert excel11.xlb somehow, or can I just change the name to excel10.xlb?

This change is forced on me because I do not have a disk for Office 2003 (the last version I have been using) but I do have one for Excel XP. I am assuming that most, if not all, of my 2003 applications are backwards-compatible with XP!

Answers and any other helpful comments would be welcome. I have already tried the transfer once and got it wrong in a way that I cannot fix.

**martindwilson** · 12-28-2010, 11:50 AM

what is excel xp? oh i take it you mean
Excel 2002 (version 10)

**hershmab** · 12-28-2010, 12:03 PM

Originally Posted by martindwilson

what is excel xp? oh i take it you mean
Excel 2002 (version 10)

Yes, that is what it seems to have been called originally.

**royUK** · 12-28-2010, 12:27 PM

Your personal.xls and udf.xls should probably not be a problem, unless there are features in the code not available in 2002.

Find your current .xlb, and change it's name so tht you don't lose it. Then save your new .xlb with the name excel10.xlb. Not sure if this will work, but you can restore the original .xlb by changing the name back