Hi, I work at a firm which uses a lot of Excel and generally we will link various data across workbooks. This is done by inserting links across workbooks into the formulas, but recently we have run into an issue with some particular documents where the formulas/links in the documents 'forget' the link and it asks/demands that the file location is input via a File Explorer every time we want to refresh the document. Clearly this is a bug, whether it has something to do with our formulas, how we have our document/data structure designed, or something intrinsically wrong with Excel itself.

If anybody has any suggestions on what to do, I would really appreciate the help.