| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referenced cell shows ='EE-4201-Mp-11'!D3, not the value
Sometimes when I want to reference the value in a cell from another worksheet
I get this in the cell ='EE-4201-Mp-11'!D3. It is showing the worksheet and the cell and not the value in that cell. What is causing this. It does not do it all the time. The format for the cell makes no difference. I am sure this must be a simple toggle that needs to be set. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
| See where a cell is referenced | New Users to Excel | |||
| cell shows 0 when referenced cell is null | Excel Worksheet Functions | |||
| How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
| cell shows 20. Formula shows 20. why not 540/27 | Excel Worksheet Functions | |||
Threaded Mode
