SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I currently have two spreadsheets housed in Excel Services in a Sharepoint Hub. These two spreadsheets are linked. However, the values on my main spreadsheet will only update 1. if the source document is opened or 2. if I click the Edit Links button and then click the Update Values button. I tried clicking the Startup Prompt button in the Edit Links dialogue and selecting "Don't display the alert and update links", but that didn't work. Is there any programming that can be added to the main spreadsheet to force it to update values without needing to click on the Edit Links button and then click on Update Values? If I have these same two documents housed on my computer, the links update when the main document is open. Is there a way to get the spreadsheets to act this way in SharePoint?

Any assistance you can provide would be greatly appreciated.

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.