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