Thank you for responding.

We are using Excel 2000.

The file names format is "30001_Ritz-Lot-13-C_________DJ-05-01.xls". The two
differences between the names would be the number of "_" spaces between the
last letter and the "DJ" part. Typically, the name fills the window where you
enter a new file name.

Is it possible that Excel just doesn't like names of this length?

"Bill Manville" wrote:

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