Formulas not working

[Larry]

I have a workbook in which none of the formulas are working. Even
something as simple as "=j67" which should just show the value from J67
does not work.

Other workbooks are all fine, it's just this one that has the problem.
I have even had multiple workbooks opened at once and can switch back
and forth, where it will work in all others, but then it doesn't in
this one.

This workbook does have some code attached to it, but this doesn't seem
to be the problem as I even disable macros when opening it and it still
doesn't work.

When you type the formula (any kind) into a cell and press enter, it
just continues to show the formula as if it were text. I have checked
and checked, there is nothing else in the cell except the formula
starting with "=". I have tried multiple cells on the workbook and
multiple sheets in the workbook, all with the same effect.

Just before I posted this msg, I did try adding a new worksheet to the
workbook and formulas work fine on that new worksheet! What the heck
could be going on with the other worksheets?

 

[Pete_UK]

You may have re-calculate mode set to manual - press F9 to see if it
re-calculates. Go to Tools | Options | Calculation (tab) and set the
re-calculate mode to Automatic.

Hope this helps.

Pete

 

[Larry]

No, it's not that. That's one of the first things I checked, then
verified, by testing other workbooks and having the formulas working on
them.

 

[Pete_UK]

OK, try this then. Highlight a column with formulae in it, click Data |
Text to Columns then click Finish - does this fix it? If it does, apply
this to all the other columns.

Pete

 

[Larry]

That did it! THANKS!

Can you explain what happend here? I've never seen/used that "feature".

 

[Larry]

That did it! THANKS!

Can you explain what happend here? I've never seen/used that "feature".

 

[Pete_UK]

I saw this tip in another posting a few days ago - I think it was from
RagDyer - and I thought it was a good one to remember. I've used it
myself a few times since then when copying data from PDF files.

I thought from your description that all the cells had been formatted
as text, and the fact that it worked now confirms it. Perhaps the macro
that you disabled did something to all the cells in the worksheet.

Anyway, thanks for feeding back - glad it worked for you.

Pete

 

[Ron Laffey]

Thank you very much, Pete.

I really only use one page of Excel, and periodically, one or more
columns do the same with me. I've had luck in the past getting the
results I want, but never sure exactly what was done, or how I did it.
This works. Not really sure what is happening, but it works.

Once again, thanks.

Ron