Feb 9 2004, 03:43 PM
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?
Feb 9 2004, 03:54 PM
Are your preferences set to "manual update"? If so. change it to automatic. Hope this helps!
Feb 9 2004, 04:02 PM
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.
Feb 10 2004, 08:25 AM
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?
Feb 10 2004, 09:23 AM
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.
Feb 10 2004, 10:49 AM
You're welcome. Glad you got it working!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here