Is there any programming that can be added to a spreadsheet to force it to update values without needing to click on the Edit Links button and then click on Update Values? I have a spreadsheet that contains links to another document that is housed on a webserver. However, the values on my 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 and selecting "Don't display the alert and update links", but that didn't work. Is there a way to force it to update on open?

Any assistance you can provide would be greatly appreciated.