Have you tried going to the EDIT menu LINKS and then clicking on the STARTUP
PROMPT?

"Greg Wetzel" wrote:

Several workbooks have refused to update linked cells at random. Closing and
reopening doesn't update links. Only recreating the link seems to work.
This has occurred on various computers, with various workbooks. Has anyone
experienced this and found a cause?