Formulas not working anymore

  • Thread starter Subhadhrã \(Bhakti\)
  • Start date
S

Subhadhrã \(Bhakti\)

Hello,

I have Excel 2002 and have been using it for my Pet Sitting business.
All of a sudden, today, all my cells with formulas in them, aren't working!
I have very basic formulas [ie: =sum(e35-b34)] and similar things...
Yesterday, they were working just find... and today, NONE of them are
working!

I can get them to work if I re-enter the formula, but I have hundreds of
cells with formulas. Even doing the "fill formula" (Clicking on a cell and
then pulling the corner to copy that formula to the other cells) doesn't
work.

Would anyone have any idea what may happened? I have a years' worth of
clients in there.

I didn't DL the SP2 yet... I have a Firewall... I didn't DL any new
programs... I don't have any virii...

Please help!

Thank you,
Bhakti
 
S

Subhadhrã \(Bhakti\)

WOW! THAT was fast!!!

So, I followed your instrux and it was already checked. So, I unchecked it
and checked it again. IT WORKS!!!

Maybe it just needed a "kick start" again. :))

Thank you SO MUCH, Norman. I truly appreciate the expedient and very
helpful assist!

Blessings,
Subhadhrã


Hi Subhadhrã (Bhakti),

Try:

Tools | Options | Calculation | Automatic
 
Top