Microsoft Excel - How can I reference a cell in another workbook when both workbook are saved on OneDrive?

Asked By Dennis H on 19-Feb-17 10:56 PM

I open both workbooks, enter = and then click on the cell in the other workbook. SOP.

So far so good.

When I close both workbook, I get an X on the cloud in the notification area.

I open the workbook with the X, resave and it updates.


How can I correct this problem and have it work as it does when not using OneDrive?


Thank you