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.

formulas don't work anymore
 

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

formulas don't work anymore
 

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

formulas don't work anymore
 

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