Right, pure links works; but if you try to use that link in formulas (my case
sumif) doesnt work anymore until you open source file too.
I think problems came from translation (composing) path.

"Bill Manville" wrote:

Some links work, don't they?
Are the ones that don't work more complicated formulas (e.g. VLOOKUP)?
Some formulas are just too difficult for Excel to compute without
having the source workbook open.

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