I don't recognise "Update links to other documents"
Which version of Excel are you using? (it always helps if you say)

Since you mention Trust Center I am guessing it is 2007.

Ah - yes - now I see it in Office Button Excel Options Advanced
When calculating this workbook.

In Excel 2002 there is a checkmark for "Update Remote References" which
I think is equivalent despite the change in wording. Remote references
are things like DDE links to other applications, not links to other
workbooks; chances are you don't have any of them. That setting is not
saved with the document, I think.

The general setting you need is, I think, Office Button Excel Options
Trust Center Trust Center Settings Prompt User on Automatic
Update for workbook links

Plus, for the specific workbook you need to ensure that Data
Connections Edit Links Startup Prompt is set to "Let users choose
whether to display the prompt or not"




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