F
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?
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?