We believe that when you have several Excel workbooks which are linked via formulas, if you update a value in one workbook, the other workbook values will update when the file is opened and update is selected from the dialog. We do not believe that this is what happens now that all the workbooks are saved on Sharepoint sites.

Can anyone verify that the Sharepoint saved workbooks do not update unless the linked files are also opened?