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

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

It tells me that the data I'm using is the wrong type. Here is the actual
cell formula: ='310.03'!BY7:CC7. The sheet name I'm referencing from is
310.01. It is referencing the value in a merged cell. I knew about the
general format issue, that fixes it sometimes but this one really has me
beat...

"Sloth" wrote:

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

try this
='310.03'!BY7

as Renegan says a merged cell is still just one cell.

Your probably getting the #VALUE error.. You threw me for a loop when you
said "all that displays is the formula."

"Loyd" wrote:

It tells me that the data I'm using is the wrong type. Here is the actual
cell formula: ='310.03'!BY7:CC7. The sheet name I'm referencing from is
310.01. It is referencing the value in a merged cell. I knew about the
general format issue, that fixes it sometimes but this one really has me
beat...

"Sloth" wrote:

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

When you merged cells that doesn't mean you have your value in several
cells. If your source cell is merged cells 'sheet1'!b1:b5 then your
value is probably in b1. So your formula should only show (cell on
sheet2) ='sheet1'!b1).


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=528140