Quote Originally Posted by Argile79 View Post
yeah, hah as soon as i sent that i recalculated it, so that should be no...now it seems to be working, for a while it was keeping yes forever and then when it hit no would be no forever, even when i was in yes's..but now it seems to be good..so my bad..thanks so much, i sent it to a hand full of people to see if we can break it..but til then, you guys rock..thanks alot. Ill keep you posted.
Possibly you have your Excel set to not do Auto recalcs?

Go to Tools|Options and in the Calculation tab.. check Automatic in the Calculation area.