Hyperlinks - Changed my Excel - how do i change them back

[knightengale]

Hi

I have a rather big excel file that has lots of hyperlinks. Unfortunately Excel has decided to change the path in all of these hyperlinks when i moved the file.

Now for some reason it doesnt change then back..

Any ideas how to do this / why it did it in the first place?


Thanks

 

[knightengale]

Further to this..,. I have noticed some hyperlinks are changed depending on where the file is.. Where are others aren't.

Any idea of how to 'lock' then into a set location?

Thanks