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?
Bookmarks