Change your calculation setting to automatic
Tools - Options - Calculations - Automatic

I hope this helps, I had the same problem


"Neil22" wrote:


I am familiar with the two solutions listed and have tried them all.
Also this problem acts like the formula is a absolute reference, no $'s
are in the formula.

Thanks,
Neil


--
Neil22
------------------------------------------------------------------------
Neil22's Profile: http://www.excelforum.com/member.php...fo&userid=4179
View this thread: http://www.excelforum.com/showthread...hreadid=481730