I've got a worksheet, and it references values in a second worksheet.
The values are transposed (via cell formula from the second worksheet)
onto the first worksheet.

When the cell formula is: ='sql link'!u3

The values from the second worksheet show up fine. So I have a column
of these:

='sql link'!u3
='sql link'!v3
='sql link'!w3
='sql link'!x3
='sql link'!y3

at the bottom I have a formula that sums those values:

=sum(d2:d6)

I get zero in that field, though the total of the values above do not
equal zero.

If I tried a test cell below the sum field:

=d2

and it correctly picks up the value of the field from the column above.
The sum field should work. Why isn't it?