Updated links

[Thomas]

Hi,

When opening a spreadsheet that has links to other
workbooks, Excel asks if I would like to update. Despite
pressing "don't update" all the references turn to #REF.
That didn't happen before... Any ideas as to how to avoid
it?

Thanks in advance,
Thomas

 

[Jimmy L. Day]

You should opt to update the links instead of "don't update".