View Single Post
  #2   Report Post  
Ken Wright
 
Posts: n/a
Default

See if he has the following option and then use it if so:-

Edit / Links / Change Source

You will need to do it for each unique File link, but hopefully that's not
many

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Andre Croteau" wrote in message
...
Hello

Recently the IT dept just changed the laptop for our F&A Manager. When he
opens the Excel files, the links in the all cells are changed to this
folder:

"'C:\Documents and Settings\neilm\Application
Data\Microsoft\Excel\XLSTART\DATAX\......", even after he clicks "NO" to
update the link.

The original link in the old laptop is "C:\DATAX\.....". Have you seen any
similar cases before ? He can change the links manually, but it will take
lots of time and he has to verify every link in every Excel file.

The new laptop is using Office 2000 SR1, while the old laptop is using
only
Office 2000.



The transferring of his files was done as follows:

- turned on both laptops and logged into the network


- in his new laptop, mapped a network drive to his old laptop


- copied the files from his old laptop to the new laptop, in the same

locations in new laptop



Does enyone know why this happened (to avoid hapening again), and is there
any easy way to fix it?

Thanks !

André