I have a spreadsheet which, until recently, on opening updated links to
external spreadsheets (whether or not the file was already open). Now, for
some strange reason, it updates all but one link but it will do so when that
file is already open. I get the message "The workbook contains one or more
links that cannot be updated".

Any ideas why this should happen please?

Thanks.

Bill Ridgeway