I have a workbook that has many cells that link to a server on the other side of the planet. If I manually open this workbook I get the "This workbook contains links to other data sources." And the option to "Update" or "Don't Update"
If I choose to not update, everything works great. If I choose to update, the worksheet takes 10-15 minutes to open. I have tried to go to tools-->options-->Edit and uncheck "ask to update automatic links" but this makes the default behavior updating.
I want to open this workbook using a scheduled task and a batch file, and have it not update, and then run a macro. Any suggestions on how to do this?
P.S. I searched for "don't update" and had zero results. My apologies if this is a common question.
Bookmarks