Excel Formulas Broken after profile migration

[mrjules]

We recently migrated a workgroup to a new Domain. Users have several excel
2003 spreadsheets used for financial purposes. When a user opens a
spreadsheet and changes a $$ amount in one of the fields, all fo the cells
that should be updated change to #NAME. As a matter of troubleshooting, I had
the user log into their old workstation profile and open the same
spreadsheets, and the formulas work properly there. All profiles were
migrated with the XP FAST Wizard. So, my question is, how do I restore
functionality to these formulas? Can i Copy something from the App data
directories in there old profiles to the new profiles? Any help would be
greatly appreciated, as this is and urgent issue.

 

[Gordon]

We recently migrated a workgroup to a new Domain. Users have several excel
2003 spreadsheets used for financial purposes. When a user opens a
spreadsheet and changes a $$ amount in one of the fields, all fo the cells
that should be updated change to #NAME. As a matter of troubleshooting, I
had
the user log into their old workstation profile and open the same
spreadsheets, and the formulas work properly there. All profiles were
migrated with the XP FAST Wizard. So, my question is, how do I restore
functionality to these formulas? Can i Copy something from the App data
directories in there old profiles to the new profiles? Any help would be
greatly appreciated, as this is and urgent issue.

That suggests to me that the cells are all links to external workbooks. Can
you do a find and replace and replace the old link with the new? (long time
since I dealt with linked workboojs so can't be precisely sure...)