Data Links not working

[Spikenaylor]

Hi there,
My spreadsheets have been working fine for years, however the all seem to be exhibiting the same issue. on opening, I get the message box - 'We can't update some of the links in your workbook right now, you can continue without updating their values, or edit the links you think are wrong'

Spreadsheet opens and then I check the Data | Edit Links

One of The links shows as UnKnown, but when I check status I get Error: Worksheet not Found

I then Open Source and the source spreadsheet Opens, so the link must be working.

Any cells that use this link DO NOT get updated unless I open the source spreadsheet.

This is now happening to all my spreadsheets with links to this one spreadsheet, but as the link will open, I cant understand why this is happening



Does anyone have any ideas?

 

[russelldt]

Same for me…..did you have any success to resolve this?