Per Baden wrote:
In my opinion it still should remove the checkmark in
Office Button Excel Options Advanced When calculating this workbook
and popup with the question.


Unless you have links to non-Excel files, the question in ...Advanced is
irrelevant since it only applies to such links.

Clearly the trusted location seems to be making a difference, which
surprises me. I will investigate further when I have time.

If all else fails, you could run a different workbook which asks the refresh
question and then loads the intended workbook with/without refreshing the
links.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup