We have a spreadsheet that has been updated on a monthly basis for at least six years. Every time we open the workbook, we get an error that a link cannot be updated. The link does not exist in the link box, nor can we find on any sheets. I've already checked for hidden sheets and have done a search on every sheet for a specific word that exists in the link. I've not been able to find this link anywhere. I've also checked all the headers and footers.
Any suggestions on where this link might be hiding?
I've even broken the original workbook into five smaller workbooks. I made a copy of the sheets into new workbooks. This broken link message shows up when all five new workbooks are opened. I've been trying to find this link for over a year. It is slowly driving me mad!