does the formula recalculate when you press F9

have a look at <tools<options<calculation
is it on manual?

This may have been caused by a previous book opened and saved with the
setting on manual.


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=400209