if it's just showing the formula, then you probably have the cell formated as
text. Try changing the format to general. You might have to edit the
formula before the format change will take effect (select the cell, hit F2,
hit enter).

"Loyd" wrote:

I try to reference another (merged) cell on a different page in the workbook
(Example: (cell on sheet2) ='sheet1'!b1:b5) to a cell on another page which
is also merged and all that displays is the formula ( I don't think the fact
that the cells are merged is affecting the answer). We do a lot of
referencing in our forms so we can put the project number, revision, etc. on
one sheet and it updates all the sheets of the specification. Sometimes it
works and sometimes it doesn't. What is wrong and how do I fix it?
Thanks - sloth march