Hello,

Workbook1 has a vertical column of 5 cells (with values of 1, 2, 3, 4, 5)
named NUMBRS. Workbook2 is linked to Workbook1 (at least I think it is!!),
and has the formula SUM(NUMBRS). However, the formula results in zero.
Apparently, Workbook2 does not recognize the range name NUMBRS in Workbook1.
Is there a reason for this? Your help is appreciated.

Thanks,

Jay