software

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?


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

goto
tool,options,calculation, set calculate to automatic--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=531213If you get the formulas as text strings press ctrl ` (grave accent) or
toolsgt;optionsgt;view formulas;
If they don't calculate toolgt;optionsgt;calculation and set to automatic

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Trinaquot; gt; wrote in message
...
gt;I have simple Excel formulas (like sum a column). All of a sudden none are
gt; working, in any spreadsheet I open. I must of hit something. What do I
gt; do?Easy peasy once you know -- thank you so much

quot;davesexcelquot; wrote:

gt;
gt; you can start by checking if your workbook is set to automatic
gt; calculate
gt;
gt; goto
gt; tool,options,calculation, set calculate to automatic
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=531213
gt;
gt;