editing liked cells
 

I have a worksheet that has a data input page linked to a number of pages in
which the inputted data appears. eg on data page one,cell A6 is linked by a
formula to a cell on the data input page - (=data!A15) . If I try to edit the
formula, to say
(=data!A18) then the formula appears in the cell rather than the data it is
linked to.
I think I am missing something simple, but could someone help me resolve
this please?

editing liked cells
 

You should do three things:

1. make sure calculation mode is set to automatic
2. make sure the cell is not formatted for text
3. make sure display formula is not set (CNTRL~)

--
Gary's Student


"Roger Thompson" wrote:

I have a worksheet that has a data input page linked to a number of pages in
which the inputted data appears. eg on data page one,cell A6 is linked by a
formula to a cell on the data input page - (=data!A15) . If I try to edit the
formula, to say
(=data!A18) then the formula appears in the cell rather than the data it is
linked to.
I think I am missing something simple, but could someone help me resolve
this please?

editing liked cells
 

Thanks, The problem was due to the cell being formatted for text

"Gary''s Student" wrote:

You should do three things:

1. make sure calculation mode is set to automatic
2. make sure the cell is not formatted for text
3. make sure display formula is not set (CNTRL~)

--
Gary's Student


"Roger Thompson" wrote:

I have a worksheet that has a data input page linked to a number of pages in
which the inputted data appears. eg on data page one,cell A6 is linked by a
formula to a cell on the data input page - (=data!A15) . If I try to edit the
formula, to say
(=data!A18) then the formula appears in the cell rather than the data it is
linked to.
I think I am missing something simple, but could someone help me resolve
this please?