I have recently upgraded a workbook from Excel 2003 to Excel 2007. It contains many links to an external workbook that resides in the same folder (C:\FOLDER\SLP_Data.xlsm). These files are distributed to many people and almost all of them are having the same issue.

After awhile, the links in the workbook change to a location in their profile. (C:\Documents and Settings\[user]\Application Data\Microsoft\Excel\SLP_Data.xlsm) These links happen to reside in VLOOKUP functions, but I don't think that is relevant.

I have been unable to determine what is causing this change. None of the files are moved from their original location on the C drive. I can update the links to correct the problem, but the problem comes back.

The best I can figure is that the AutoRecovery function is involved, but I can't be sure. Has anyone run into this issue?

Here is the original formula and the changed formula:

=IF(ISERROR(VLOOKUP(I10,'C:\SLP\SLP_Data.xlsm'!Sep,9,FALSE)),"",(VLOOKUP(I10,'C:\SLP\SLP_Data.xlsm'!Sep,9,FALSE)))

=IF(ISERROR(VLOOKUP(I10,'C:\Documents and Settings\kewing\Application Data\Microsoft\Excel\SLP_Data.xlsm'!Sep,9,FALSE)),"",(VLOOKUP(I10,'C:\Documents and Settings\kewing\Application Data\Microsoft\Excel\SLP_Data.xlsm'!Sep,9,FALSE)))