If the choice is keeping the calculation in the original workbook and bringing
back one value

or

bringing back 100's of values and doing the calculation in the "receiving"
workbook

Then I would try to bring back the one value.

And depending on where the workbook is (on a server far away???) and whether
that workbook is open, you may be disappointed how slow it can be.

But if you have no other options, you can open the sending workbook first, then
open the receiving workbook and it'll be very fast.

If I were you, I'd experiment with a few formulas before making a decision.



Graham Y wrote:

Dave thanks, is that hungry on resources, I have hundreds of links!

Is it better to link to the result of a calculation or to have the formula
in the summary sheet?

--

Dave Peterson