Links and #VALUE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After requesting the updating of links from closed source documents, the cells in the destination workbook are returning #VALUE!. Once the source documents are open the links work ok.

Any suggestions on how to correct this, so I don't need to open the 50 or so source workbooks (which in the next 6 months will grow still further!) gratefully received.

Thanks

DR
 
David Reed said:
After requesting the updating of links from closed source documents, the
Click to expand...
cells in the destination workbook are returning #VALUE!. Once the source
documents are open the links work ok.
Any suggestions on how to correct this, so I don't need to open the 50 or
Click to expand...
so source workbooks (which in the next 6 months will grow still further!)
gratefully received.
Thanks

DR
Click to expand...

What functions are you using in the formulas that return the #VALUE! error?
Some functions only work with links to other workbooks if those workbooks
are open.
 
Hi

Obviously you use links as references in some formulas, but there are some
functions (p.e. SUMPRODUCT), which don't work with closed source workbooks.
You can mirror source data into some hidden sheet(s) (simple links with
check for empty cell), and referring in your formulas to mirrored data, but
with 50 source workbooks, ... hm, maybe you have to review your design, or
to select another tool for it.


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets


David Reed said:
After requesting the updating of links from closed source documents, the
Click to expand...
cells in the destination workbook are returning #VALUE!. Once the source
documents are open the links work ok.
Any suggestions on how to correct this, so I don't need to open the 50 or
Click to expand...
so source workbooks (which in the next 6 months will grow still further!)
gratefully received.
 
SUMPRODUCT does work with closed workbooks; SUMIF doesn't. This is one of
the reasons I now always use SUMPRODUCT in preference to SUMIF.
 
Back
Top