Links and #VALUE

[David Reed]

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

 

[Paul]

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

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.

 

[David Reed]

Problem has been solved.

Apparantly SUMIF doesn't update from closed source workbooks!


DR

 

[Arvi Laanemets]

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

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.

 

[Paul]

SUMPRODUCT does work with closed workbooks; SUMIF doesn't. This is one of
the reasons I now always use SUMPRODUCT in preference to SUMIF.