Excels links

**sura** · 07-27-2007, 06:32 AM

Hi

I work on a big excel document, on which i have 15 000+ video links, going to video files on my different hard drives (C:/ ; D:/ ; E:/)

Now I'm buying a new computer, so I can have on one computer the video files, and on the other my excel document. Both computers are connected via LAN.

How can i make all the links change from

C:/program files/...

to //Computer2:/C:/program files/...

Thanks a lot for your help

**davesexcel** · 07-27-2007, 06:45 AM

Find and replace should work

Find
C:/program files/...
Replace with
//Computer2:/C:/program files/

**sura** · 07-27-2007, 11:35 AM

Thanks for your fast reply

When i try to do as you say, I get a message saying it's not finding c:/programfiles..., so i can't replace anything.

**davesexcel** · 07-27-2007, 02:10 PM

No sure why it didn't work,
did you click on option and selected formulas?

**sura** · 07-28-2007, 08:36 PM

yes formula's ticked

Does it work for you?

**davesexcel** · 07-29-2007, 01:27 AM

Originally Posted by sura

yes formula's ticked

Does it work for you?

It worked for me but I am just creating my own examples...
If it is possible, could you maybe attach a zipped example workbook with the formulas so somebody can look at it and hopefully find a solution for you,
Thanks

**sura** · 07-31-2007, 05:41 AM

k here it is : I want the link on video 12 & on video 13 becomes C:/Document and settings/...../.....

instead of I:/ Document of settings/...../.....