Referenced cell displays formula, not data
Press CNTRL + TILDE Key whch is available above the Left Tab Key.
Tilde key (`) or (~)
Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------
"MZ" wrote:
I downloaded a form template and linked it to my data; when I use the = sign
to insert my data into the template, some €“ though not all €“ cells display
the formula of the cell reference rather than the data that is actually
contained in the cell
Example:
Cell D10 in datasheet contains text; instead of displaying the text in the
template, it shows the following formula that is the reference address:
='[data sheet.xlsx]'!$D$10
--
MZ
|