I don't know why this would suddenly start happening, unless you had
changed the link source using Edit Links and the resultant formula
became too long when including the full path to the source file.

The 1024 limit is not on the length of the linked file name itself but
on any formula incorporating that name.

If, for example you had a formula
=IF('C:\MyDir\[MyBook.xls]Sheet1'!A1=0,"",'C:\MyDir\[MyBook.xls]Sheet1'
!A1)
and you used Edit Links to change the source to some long network
path then the formula length would increase by twice the change in path
length.

Can you identify a formula that is giving the trouble?
If so, please post it here in case it triggers some other thoughts.


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