Office365 | Linked Excel file no more links to each other after new Update.

Hi Everyone,

I am not sure if this is the right place to ask about this issue. I am struggling with this issue since office365 pushed update on 27th Nov 2017. I was waiting if Microsoft will solve this in there next update but no any luck.

We have already tried the recent update still the same. Due to this issue we have stopped automatic update for our office 365 and its all good with the Old Version before 27th Nov 2017.

 

ISSUE:

When opening two files that have links to one another, excel should recognise that the files are open and update accordingly.However, now for some unknown reason, this is no longer the case if the files are opened by double clicking on them from their destination folder. Instead, these files needs to be opened from Excel by going to File -> Open from within Excel before they will link to one another.

 It is as if the files are opening in their own instance of Excel rather than in the same instance of Excel. This used to be the case in a much older version of Excel, but should not be happening with the latest versions.

e.g. open 2 new workbooks. In book 1, cell A1, make the cell =A1 of book 2.

In book 2, make cell A2 = A2 of book 1.

Now save both files and close them. Open them from the destination folder by double clicking, and if you make a change to the value of cell A1 in book 1, it will not update in book 2.

Now close both files and open them from WITHIN excel, repeat the above and it works.