My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Quick question about cell updating
|
|
 Feb 9 2004, 03:43 PM
Post
#1
|
|
|
UtterAccess Addict Posts: 122 From: Houston, TX  |
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
Post
#2
|
|
|
UtterAccess Guru Posts: 646 From: Central Illinois |
Are your preferences set to "manual update"? If so. change it to automatic. Hope this helps!
|
|
|
|
|
Feb 9 2004, 04:02 PM
Post
#3
|
|
|
UtterAccess Addict Posts: 122 From: Houston, TX |
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
Post
#4
|
|
|
UtterAccess Guru Posts: 646 From: Central Illinois |
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
Post
#5
|
|
|
UtterAccess Addict Posts: 122 From: Houston, TX |
It appears to be working now. I've never seen that before. Microsoft solution to everything: Re-Boot and try again (IMG:http://www.utteraccess.com/forum/style_emoticons/default/smile.gif) thanks for the help command.
|
|
|
|
|
Feb 10 2004, 10:49 AM
Post
#6
|
|
|
UtterAccess Guru Posts: 646 From: Central Illinois |
You're welcome. Glad you got it working!
|
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 24th May 2013 - 03:38 AM |