Forum Discussion
HELP! Excel displaying link instead of linked cell value? (='Short List'!D31, instead of Jeff).
Donald McAlister, the problem is if your source cell formatted as text the linked cell is automatically reformatted to text when you enter or edit formula (more exactly when you switch on cell edit mode by clicking on it or by F2)
After that it shows the formula, not linked value.
It's something new for me, but Microsoft published the support article about the issue in April this year https://support.microsoft.com/en-ph/help/135506/cell-linked-to-text-formatted-cell-shows-formula-not-value
I'd recommend to change your source format (column D and others) in Short List sheet on General, when it works. Please note, you have to reformat you column with links in Qualified back to General. I did that for E column (Short List) and Column M (Qualified) in attached.
Also, it was WORKING for a week and just stopped.
I am TOTALLY puzzled by this.
If you could submit the file removing all sensitive information and keeping only few cells (which work and ones in question) that will be easier to check.
Donald McAlister, the problem is if your source cell formatted as text the linked cell is automatically reformatted to text when you enter or edit formula (more exactly when you switch on cell edit mode by clicking on it or by F2)
After that it shows the formula, not linked value.
It's something new for me, but Microsoft published the support article about the issue in April this year https://support.microsoft.com/en-ph/help/135506/cell-linked-to-text-formatted-cell-shows-formula-not-value
I'd recommend to change your source format (column D and others) in Short List sheet on General, when it works. Please note, you have to reformat you column with links in Qualified back to General. I did that for E column (Short List) and Column M (Qualified) in attached.
SergeiBaklan I know this solution is several years old at this point, but I just wanted to chime in and say thanks, I had this very same issue come up today and it was driving me nuts. I would have never figured out what the problem was.
