What could keep formulas from recalculating?

[Frank Marousek]

I have a workbook that I received from a company with which I do business.
On it are several worksheets (tabs). On one sheet, if I go to enter a
formula in a cell, it displays it as text instead of calculating a value.
For example, if I type

=A1+A2

it will display that exact text in the cell as opposed to displaying the sum
of cells A1 and A2.

On other worksheets in the same workbook, entering formulas seems to work
just fine. I have checked in Options, and auto-calc is checked (pressing F9
also has no effect).

I can only assume that there is some setting of which I am unaware that is
preventing the forumulas from being calculated. Does anyone know what could
be causing this behavior?

 

[The Red Cardinal]

I have a workbook that I received from a company with which I do
business. On it are several worksheets (tabs). On one sheet, if I go
to enter a formula in a cell, it displays it as text instead of
calculating a value. For example, if I type

=A1+A2

it will display that exact text in the cell as opposed to displaying
the sum of cells A1 and A2.

On other worksheets in the same workbook, entering formulas seems to
work just fine. I have checked in Options, and auto-calc is checked
(pressing F9 also has no effect).

I can only assume that there is some setting of which I am unaware
that is preventing the forumulas from being calculated. Does anyone
know what could be causing this behavior?

If the boxes are formatted as Text, then whatever is entered will be treated
as text only. If you can see the equals sign, this is the most likely
explanation...

 

[Vladikavkaz]

I have a workbook that I received from a company with which I do business.
On it are several worksheets (tabs). On one sheet, if I go to enter a
formula in a cell, it displays it as text instead of calculating a value.
For example, if I type

=A1+A2

it will display that exact text in the cell as opposed to displaying the sum
of cells A1 and A2.

On other worksheets in the same workbook, entering formulas seems to work
just fine. I have checked in Options, and auto-calc is checked (pressing F9
also has no effect).

I can only assume that there is some setting of which I am unaware that is
preventing the forumulas from being calculated. Does anyone know what could
be causing this behavior?

does =sum(a1+a2) give the same message?

 

[wiseman]

You could try going to Tools, Options, View tab, and untick / uncheck the
Formulas.
Barbara