I have some excel sheets that are linked together and the location of the
file server changed. Now when one sheet is opened it updates fine but other
sheets and fields in the sheet get the following error:

this workbook contains 1 or more links that cannot be updated

Any thoughts?