External references in Excel return #ref

Hello,

I have an Excel worksheet (destination) I am working on using OneDrive. One of the cells is linked to another worksheet in a different OneDrive folder (source). When I open the destination document first, it tells me  "This workbook contains links to one or more external sources that could be unsafe" and it gives me the option to Update, Don't Update, and Help. Regardless of whether I click Update or Don't Update, the linked cells in the destination doc return #REF!.  However, when I open the source doc and the destination doc at the same time, the #REF! becomes the numbers that they used to be. I would like to not have to open both the source and destination doc every time I open the destination worksheet. Could somebody please help? Thank you.

Sebastian