Hi,
According to your description, I would suggest you can firstly try transferring the data from original file to a new created workbook.
If it doesn’t work, please edit the links in the worksheets to see if it is caused by broken links. And monitor on the linked files to rule out the cause of network issue.
The next step is following the steps in the article below to have a troubleshooting in Excel:
http://support.microsoft.com/kb/280504
Sincerely
Rex Zhang
Rex Zhang
TechNet Community Support
