Excel Woes - Formula bug (I guess)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mikeydread1 - 18 May 2006 16:37 GMT

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.

Reply to this Message

Andy - 18 May 2006 16:44 GMT

Hi

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

Andy.

> 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.

Reply to this Message

Niek Otten - 18 May 2006 16:44 GMT

Tools>Options>Calculation tab, check Automatic

Signature

Kind regards,

Niek Otten

| 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.

Reply to this Message

kraljb - 18 May 2006 16:44 GMT

Try checking your Tools->Options->Calculation and make sure that it is
on Automatic.

Signature

kraljb

Reply to this Message