software

A spreadsheet worked correctly for months but suddenly stopped
calculating. The function is =SUM(C2:O2) and is copied down for all the
rows.

Cells are formatted as accounting. I deleted and recreated.

Any ideas?

thanks!--
woodsie2523
------------------------------------------------------------------------
woodsie2523's Profile: www.excelforum.com/member.php...oamp;userid=34348
View this thread: www.excelforum.com/showthread...hreadid=541177Maybe toolsgt;optionsgt;calculation and make sure it is automatic

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;woodsie2523quot; gt;
wrote in message
...
gt;
gt; A spreadsheet worked correctly for months but suddenly stopped
gt; calculating. The function is =SUM(C2:O2) and is copied down for all the
gt; rows.
gt;
gt; Cells are formatted as accounting. I deleted and recreated.
gt;
gt; Any ideas?
gt;
gt; thanks!
gt;
gt;
gt; --
gt; woodsie2523
gt; ------------------------------------------------------------------------
gt; woodsie2523's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34348
gt; View this thread: www.excelforum.com/showthread...hreadid=541177
gt;

Yes! That was it! Thanks so much!!--
woodsie2523
------------------------------------------------------------------------
woodsie2523's Profile: www.excelforum.com/member.php...oamp;userid=34348
View this thread: www.excelforum.com/showthread...hreadid=541177It might sound obvious, but check the calculation settings in Options.

Toolsgt;Optionsgt;Calculation

Make sure it's set to automatic, otherwise you'll have to hit F9 every time
you want to recalculate the sheet.

Hope that helps.

--
ERR229quot;woodsie2523quot; wrote:

gt;
gt; A spreadsheet worked correctly for months but suddenly stopped
gt; calculating. The function is =SUM(C2:O2) and is copied down for all the
gt; rows.
gt;
gt; Cells are formatted as accounting. I deleted and recreated.
gt;
gt; Any ideas?
gt;
gt; thanks!
gt;
gt;
gt; --
gt; woodsie2523
gt; ------------------------------------------------------------------------
gt; woodsie2523's Profile: www.excelforum.com/member.php...oamp;userid=34348
gt; View this thread: www.excelforum.com/showthread...hreadid=541177
gt;
gt;

I have had this problem as well, excel keeps unselecting calculate automatic. Is there a default I can set for this?

PCakes

quot;Peo Sjoblomquot; wrote:

gt; Maybe toolsgt;optionsgt;calculation and make sure it is automatic
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;woodsie2523quot; gt;
gt; wrote in message
gt; ...
gt; gt;
gt; gt; A spreadsheet worked correctly for months but suddenly stopped
gt; gt; calculating. The function is =SUM(C2:O2) and is copied down for all the
gt; gt; rows.
gt; gt;
gt; gt; Cells are formatted as accounting. I deleted and recreated.
gt; gt;
gt; gt; Any ideas?
gt; gt;
gt; gt; thanks!
gt; gt;
gt; gt;
gt; gt; --
gt; gt; woodsie2523
gt; gt; ------------------------------------------------------------------------
gt; gt; woodsie2523's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=34348
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=541177
gt; gt;
gt;
gt;
gt;

Nope.

Excel will pick this setting up from the first workbook you open in that
session. If you're unlucky enough to open files that are set for manual
calculation, you'll have to remember to change it.

If you're the only one working on the file, make sure you save each workbook in
automatic calculation mode. Then the problem should disappear (after a
while???).

If you share files with others, make sure you open a workbook that has
calculation set for automatic first--or remember how to modify this setting.

PCakes wrote:
gt;
gt; I have had this problem as well, excel keeps unselecting calculate automatic.
gt; Is there a default I can set for this?
gt;
gt; PCakes
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; Maybe toolsgt;optionsgt;calculation and make sure it is automatic
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; nwexcelsolutions.com
gt; gt;
gt; gt;
gt; gt; quot;woodsie2523quot; gt;
gt; gt; wrote in message
gt; gt; ...
gt; gt; gt;
gt; gt; gt; A spreadsheet worked correctly for months but suddenly stopped
gt; gt; gt; calculating. The function is =SUM(C2:O2) and is copied down for all the
gt; gt; gt; rows.
gt; gt; gt;
gt; gt; gt; Cells are formatted as accounting. I deleted and recreated.
gt; gt; gt;
gt; gt; gt; Any ideas?
gt; gt; gt;
gt; gt; gt; thanks!
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; woodsie2523
gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; woodsie2523's Profile:
gt; gt; gt; www.excelforum.com/member.php...oamp;userid=34348
gt; gt; gt; View this thread: www.excelforum.com/showthread...hreadid=541177
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson