Hi there, the good news is that this could be quite a simple problem to
fix.

It is possible that someow the automatic calculation has been sitched
from automatic.

To change this go to

TOOLSOPTIONSCALCULATION

At the top you will see 3 options under the calculation heading, they
are

AUTOMATIC, MANUAL, AUTOMATIC EXCEPT TABLES

To ensure that the workbook updates itself automatically you need to
have te automatic option selected.

FYI If the manual option has been selected then if you were in your
normal worksheek simply pressing *F9* will update the data.

I hope this helps, if not please let me know

Regards,

Rob Turnbull
*Sortoutmyexcel.com*[/font]


--
Rob Turnbull
------------------------------------------------------------------------
Rob Turnbull's Profile: http://www.excelforum.com/member.php...o&userid=24278
View this thread: http://www.excelforum.com/showthread...hreadid=380310