Hi,

I have a table in excel that has 104 hyperlinks (all to different folders
with in shared network drives)

The links all worked fine until the original spreadsheet was moved to a new
location and now they don't.

I have figure out this is because they are relative links so was wondering
if there is an easy way to change them all to absolute links without redoing
them all.

I have come across a lot of people suggesting the =hyperlink formula but
that would still require retyping each one individually.

Any help would be great appreciated.

Regards