formulas don't work anymore

Hello,
I have made a sheet with some formula's in it and they used to work
properly. All for a sudden without a particular reason the formula's does'nt
work automatically.
I have to go into the cell with the formala and activate it every time again.
Can someone come up with a solution.
Thanks in advance.

Did you check Tools, Options, Calculation and check Automatic was ticked?

Originally Posted by john

Hello,
I have made a sheet with some formula's in it and they used to work
properly. All for a sudden without a particular reason the formula's does'nt
work automatically.
I have to go into the cell with the formala and activate it every time again.
Can someone come up with a solution.
Thanks in advance.

first you could try this,
Tools=>options=>calculation=>automatic=>OK

"I have to go into the cell with the formala and activate it every
time again..."
you will also notice that pressing F9 gets the formula kicking
Dave

Thanks guys this was just what I was looking for

"Bryan Hessey" wrote:

>
> Did you check Tools, Options, Calculation and check Automatic was
> ticked?
>
>
> john Wrote:
> > Hello,
> > I have made a sheet with some formula's in it and they used to work
> > properly. All for a sudden without a particular reason the formula's
> > does'nt
> > work automatically.
> > I have to go into the cell with the formala and activate it every time
> > again.
> > Can someone come up with a solution.
> > Thanks in advance.
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=486178
>
>