The first time you open a workbook, you might need to click "Enable Content" in the security warning, but thereafter the process works automatically.
If you've moved or renamed your source workbook, however, you need to update the link manually by directing Excel to the source's new location.
This setting does not automatically fix broken links -- it only updates links with an "OK" status.
The default option, "Let users choose..." uses the current user's setting, which by default displays an update prompt each time you open the workbook.
FILE/OPTIONS/FORMULAS/WORKBOOK CALCULATION should do it and it's not.
To stop the current version from automatically updating on opening: Click the Office button Click Excel Options Click Advanced Scroll to the General Section Check the box that reads"Ask to update automatic links" In previous versions of Excel, I used to be asked "Do you want to update links?
Somehow the link between the 2 has broken and won't update.
Especially for those who have a large amount of courses to maintain. He is president of Sharon Parq Associates, a computer and publishing services company. Check out I'm using Excel 2010 and have a "data workbook" linked to a "timesheet workbook".To limit what is changed in the timesheets, data is inputted into the data workbook by admin and then the timesheets are updated with new information to stop anyone altering the timesheet.Maybe you develop e Learning courses for organisations who like to move resources around, you know, to be better organised or whatever, without realising the impact this has on those who are linking to those resources? While you don't want to frustrate your learners by linking to resources that are unavailable, it can be incredibly time consuming to check and update thousands of hyperlinks, especially if this process involves manually editing, republishing and re-uploading all of your e Learning courses.