A link between two workbooks doesn't keep the value, shows #value!
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
|