Biff,

Yes, of course, in this particular context.
Was just explaining it to the OP for completeness sake <g
I didn't say that he should do it, i.e. enter the default link array
produced by Excel in this instance.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Biff" wrote:
='[Test.xls]Ken'!$AG$41:$AH$41
which needs to be array-entered
(press CTRL+SHIFT+ENTER, instead of just pressing ENTER

It'll still work if we array-enter it in a single cell, say in A1,
but then it'll return only the link value in the leftmost cell AG41.

The top left cell is the only cell that contains data so entering as an
array is pretty much useless.

Try this: =AH41

You'll get 0 because AH41 is empty.

Biff