all of a sudden the formulas don't work!

  • Thread starter Thread starter Hugh Stanley
  • Start date Start date
H

Hugh Stanley

I'm not sure how this happened, but within one of my spreadsheets
everything is dead... I was thinking some kind of arbitrary
protection got invoked, but I can't find it. Basically I have two
formulae, one that takes the first name from "Last, First" and puts it
in the next column.

The formula is there, but it just all of a sudden doesn't work.

Any help would b appreciated, I'm sure this one has cropped up before,
just not to me. ...this is Excel 97.

Thanks

- Hugh -
 
Hugh, it sounds like you're seeing the formulas but not the result. If this
is the case, try pressing Ctrl+~ (the tilde) and see if that doesn't do it.
If not, try pressing the F9 function key to recalculate all the formulas. If
that fixes it, go to the menu bar and Tools > Options > Calculation >
Automatic > OK.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
This did the trick... all my work sheets for some reason had gone from
"automatic" to "manual" calculation. Don't know why or how, but there
ya' go...

Thanks!

- Hugh -
 
Back
Top