In Excel 2010 when I open any workbook I want to have all links to other workbooks automatically updated without prompting. According to Office 2010 Excel Help, I can achieve this for each workbook by clearing the following:
File > Options > Advanced > When calculating this workbook > Update links to other documents
Unfortunately this option does not stay cleared!
  • If I go back to the option while the workbook is still open, it remains cleared.
  • If I (re)open it after saving and closing, the option is checked again.
As far as I can tell, all the other options in this category keep their last settings.

Any ideas?