Linked cell shows formula
 

I want to link to a cell on another worksheet in the same workbook. Instead
of the value of the first cell showing in the second cell, the formula from
the first cell appears in the second cell. What am I missing?

Thank you.

Linked cell shows formula
 

The cell you are linking to probably has the Text number format. The cell
with the formula probably had the General format so it picked up and now has
the Text format automatically (a 'feature' I don't care for).

So I'd change the number format of the cell with the formula to a numeric
format and press F2 and Enter. Re-entering the formula this way should make
it evaluate and return a value.

If the source cell doesn't need the Text number format I'd switch it to
something else so you don't have this problem again.

--
Jim
"Ruth" wrote in message
...
I want to link to a cell on another worksheet in the same workbook.
Instead
of the value of the first cell showing in the second cell, the formula
from
the first cell appears in the second cell. What am I missing?

Thank you.

Linked cell shows formula
 

Hi Ruth,

Hope you are using the correct formula:

=Sheet1!C1

This would be the formula in say a cell of Sheet2 where you want the value
of cell C1 from Sheet1

Rgds
Sameer



"Ruth" wrote:

I want to link to a cell on another worksheet in the same workbook. Instead
of the value of the first cell showing in the second cell, the formula from
the first cell appears in the second cell. What am I missing?

Thank you.

Linked cell shows formula
 

On Sat, 18 Aug 2007 08:10:01 -0700, Sameer Nagi
wrote:

Hi Ruth,

Hope you are using the correct formula:

I have the same problem at work, the OLE link works for cone cells,
then the next one it just displays the formula, even when formated as
above.
suspect its an unpatched machine (office 2003) - would that be to
blame? as it works on my home machine aok

Linked cell shows formula
 

Thank you for the reply. I think this is the answer. Best regards, Ruth.

"Jim Rech" wrote:

The cell you are linking to probably has the Text number format. The cell
with the formula probably had the General format so it picked up and now has
the Text format automatically (a 'feature' I don't care for).

So I'd change the number format of the cell with the formula to a numeric
format and press F2 and Enter. Re-entering the formula this way should make
it evaluate and return a value.

If the source cell doesn't need the Text number format I'd switch it to
something else so you don't have this problem again.

--
Jim
"Ruth" wrote in message
...
I want to link to a cell on another worksheet in the same workbook.
Instead
of the value of the first cell showing in the second cell, the formula
from
the first cell appears in the second cell. What am I missing?

Thank you.