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