Referenced cell displays formula, not data
 

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

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

Referenced cell displays formula, not data
 

If some, not all, cells display formula instead of values, I would say those
cells were pre-formatted as text.

Format to General then re-enter the formulas.

F2 then Enter will do the trick.


Gord Dibben MS Excel MVP

On Sun, 3 Jan 2010 04:40:01 -0800, 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

Referenced cell displays formula, not data
 

Thank you for the advice. I tried it, but it caused the document layout to
became totally corrupt. The person who made this template - a replica of the
IRS 1040 tax form - clearly wants to keep his formulas hidden from users and
has prevented any tampering with the file.
Here is the URL to see the excel sheet that the person created
http://www.excel1040.com/
--
MZ


"Ms-Exl-Learner" wrote:

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

Referenced cell displays formula, not data
 

Thank you for the advice. I tried it, but it caused the document layout to
became totally corrupt. The person who made this template - a replica of the
IRS 1040 tax form - clearly wants to keep his formulas hidden from users and
has prevented any tampering with the file.
Here is the URL to see the excel sheet that the person created
http://www.excel1040.com/

MZ


"Gord Dibben" wrote:

If some, not all, cells display formula instead of values, I would say those
cells were pre-formatted as text.

Format to General then re-enter the formulas.

F2 then Enter will do the trick.


Gord Dibben MS Excel MVP

On Sun, 3 Jan 2010 04:40:01 -0800, 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

.