Excel corrupts certain workbooks in migrating from 2003 to 2007

I got a email from a client asking for help because Excel was "destroying," to use his terminology, his 2003 workbook after conversion to the 2007 format. And, after analyzing the kind of change Excel made, I had to agree.

The basic problem is that names that are legitimate names in Excel 2003 may become unacceptable in 2007 (or later). But, a more devastating problem is with a formula using a name with a dot in it. Even though it is completely legitimate, Excel changes the dot to a colon. This causes the formula =SW1.SW2 to become =SW1:SW2. Don't ask me why. It just does. The result is the formula is all wrong and destroys the integrity of the workbook.