All of a sudden none of my Excel formulas are working...

[Guest]

I have simple Excel formulas (like sum a column). All of a sudden none are
working, in any spreadsheet I open. I must of hit something. What do I do?

 

[davesexcel]

you can start by checking if your workbook is set to automatic
calculate

goto
tool,options,calculation, set calculate to automatic

 

[Peo Sjoblom]

If you get the formulas as text strings press ctrl + ` (grave accent) or
tools>options>view formulas;
If they don't calculate tool>options>calculation and set to automatic

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[Lize7]

Easy peasy once you know -- thank you so much