I have one spreadsheet pulling information from about a dozen others on a SharePoint site. The problem is, when one of the dozen-or-so spreadsheets are updated, the master does not immediately reflect the changes/updates. Current remedy is: while master spreadsheet is open, opening one of the other spreadsheets "shocks" the master spreadsheet to reflect any updates. Any ideas on how can this be fixed?