Software

Ask something
Discussion Locked

Excel formulas don't calculate

0 helpful
2 replies

by brifd1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I place a formula into one tab of an Excel worksheet that refers to a cell on another tab of an Excel worksheet. They could be either of two kinds:

=A2
=DefinedName

In both cases, it seems that it's not calculating the result, and as a default. Very occasionally, it will eventually put in the result, but I don't know what I did that causes this to happen; in the meantime, it continues to look like the above.

I've tried F9 and the Option for ensuring that the calculation is Automatic, but neither changes anything.

Excel 2002, a network installation (so installing an update would be tricky for me to get done unless I brought my own CD in).

Thanks for your help!

Please email: abcs86@yahoo.com with your suggestions while I continue to look for the answer.

2 replies

by dklippert

If you mean that it is displayed as =A2 rather than than the Value, try
Ctrl+~
(Tilde (~) is to the left of 1 on the keyboard)
or Tools>Options and remove the check from Formulas

This discussion is closed to new replies.