Links to Excel file

[R Ormerod]

I have links set up to an excel file containing data for my presentation.

I've had to copy the files from a server location to my hard drive to run
the presentations, but none of the links have updated to the new hard drive
location.

I went into Edit => Links and did 'Change Source' for each link in turn to
specify the new file location, then saved and closed the file.

When I reopen the file, all the links revert to the old file location.

1) Why has this happened and 2) Is there a quicker way of changing multiple
links?

 

[R Ormerod]

I changed the links, saved the file, went to Edit => Links and the links all
specified the new path.

I then closed and reopened the file and all the links had reverted back to
the original path.