If you say No to updating links and then go to Edit / Links, can you
see any difference between the links that are asking you to confirm the
filename and those that don't?

Can you give an example of a link source that doesn't update correctly
and one that does?

Which version of Excel?


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