I'm pretty sure this is a sharepoint issue but I will post here to confirm and or get tips to try.

I have 3 spreadsheets A, B, and Summary as an example. Summary links to A & B and the data appears fine when I link the file to the spreadsheet. When I make a change to A or B the summary page I want to change to match what is in A or B. Locally this works fine but when I link to a file on sharepoint when changes are made they are not reflected in the summary page.

On the Summary spreadsheet I have the settings to refresh automatically but they don't update.

Also I added the path to the files being linked to the excel trustcenter.


Excel is version 2010
Sharepoint Server 2007