View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ms-Exl-Learner Ms-Exl-Learner is offline
external usenet poster
 
Posts: 506
Default 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