Forum Discussion

Donald McAlister's avatar
Donald McAlister
Copper Contributor
Sep 15, 2018
Solved

HELP! Excel displaying link instead of linked cell value? (='Short List'!D31, instead of Jeff).

I have a workbook and I have a list of people in the worksheet titled "Short List" once they are qualified, I move them to another sheet "Qualified".  

Yesterday the Qualified sheet stopped showing the values of the cells from "Short List" and will only show the link, (i.e. ='Short List'!D31).  

 

Not sure what is up, have never encountered this before.  HELP!!!

    • Donald McAlister's avatar
      Donald McAlister
      Copper Contributor
      Sergei Baklan
      No, not active. When I toggle it, the formulas in the res of the cells show up. Toggle it again, and they go back to values, EXCEPT the ones I have investigated.
      So, to be clear, I clicked on the cell that said "jeff", it then displayed ='Short List'!D31, can't get it to go back and display "Jeff" (which is the value in the linked cell).
      I cleared the cell and tried it again, and still only shows ='Short List'!D31.
      I checked several other cells and the minute I investigate the cell, it reverts to the formula.
      So my sheet has some values (because I have been working on this for a week and it has been fine until last night), and two formulas.
      I imagine any other cells I investigate will follow suit with the first two.
      • SergeiBaklan's avatar
        SergeiBaklan
        MVP

        Donald, and you you sure these cells in question are not formatted as text? If, for example, you reformat cells from General to Text after the clicking they will show you the formula only

Resources