I have two sheets "A" and "B" I allow the user to enter data on sheet "A" and combine that with other data on sheet "B", the problem is, when I go to sheet "B" the cells aren't updating?! If I go into the formula bar and just put the cursor at the end of the formula and hit return, the cell updates. anyone know what gives?

Are your preferences set to "manual update"? If so. change it to automatic. Hope this helps!

Hmmm.... Looks like I am on automatic. Is there another location besides the calculations tab under Tools -> Options ?

This might just be my windows going Hooey.

No other place that I am aware of. If you are on automatic it must be something else. If you hit F9 do your formulas update without putting the curser in the formula bar?

It appears to be working now. I've never seen that before. Microsoft solution to everything: Re-Boot and try again thanks for the help command.

You're welcome. Glad you got it working!