| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| editing cells without using mouse | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Hybrid Mode
