Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Referenced cell displays formula, not data
1 view
Skip to first unread message
MZ
Jan 3, 2010, 7:40:01 AM1/3/10
to
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
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
Ms-Exl-Learner
Jan 3, 2010, 7:51:01 AM1/3/10
to
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)
--------------------
Gord Dibben
Jan 3, 2010, 12:54:27 PM1/3/10
to
If some, not all, cells display formula instead of values, I would say those
cells were pre-formatted as text.
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
MZ
Jan 3, 2010, 3:59:01 PM1/3/10
to
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/
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:
> .
>
MZ
Jan 3, 2010, 3:58:01 PM1/3/10
to
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/
-- 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
0 new messages