software

Problem: an excel file is being used for quite some time now (about 2
years), and it suddenly stops updating cells with formulas...for
example: =SUM(c1:C10); the cell is not updated when a value is added to
say... c5. Does anyone know what is happening?, I hoping that I can get
my files back on track as soon as possible.Hi

First thing is to make sure that Calculation is set to Automatic. Go to
Tools/Options/Calculation to make sure.

Andy.

quot;mikeydread1quot; gt; wrote in message ups.com...
gt; Problem: an excel file is being used for quite some time now (about 2
gt; years), and it suddenly stops updating cells with formulas...for
gt; example: =SUM(c1:C10); the cell is not updated when a value is added to
gt; say... c5. Does anyone know what is happening?, I hoping that I can get
gt; my files back on track as soon as possible.
gt;
Toolsgt;Optionsgt;Calculation tab, check Automatic

--
Kind regards,

Niek Otten

quot;mikeydread1quot; gt; wrote in message ups.com...
| Problem: an excel file is being used for quite some time now (about 2
| years), and it suddenly stops updating cells with formulas...for
| example: =SUM(c1:C10); the cell is not updated when a value is added to
| say... c5. Does anyone know what is happening?, I hoping that I can get
| my files back on track as soon as possible.
|

Try checking your Tools-gt;Options-gt;Calculation and make sure that it is
on Automatic.--
kraljb
------------------------------------------------------------------------
kraljb's Profile: www.excelforum.com/member.php...foamp;userid=9955
View this thread: www.excelforum.com/showthread...hreadid=543347