I am new here so, hopefully I am posting in the right forum.

I have two spreadsheets, with linked data. When the two sheets are open on the same computer everything updates automatically when a change is made.
When I open the two sheets on seperate computers the destination sheet only updates to the last save. I have tried changing the security settings for both computers under the trust center but I have not had any luck. I have also hanged the work book calculation to automatic on both computers. Any suggestions?