Formulas Do Not Work Automatically

tornadowatch · Apr 10th, 2002, 10:57 AM

I have been using excel in XP Pro. Edition for several months. Just recently when I enter new data in the cells, the result does not change. The formula is correct but doesn't work. I can enter the exact same formula back in the cell and it works fine, but will not update when numbers in the cells are changed. What the heck is up with that?

AJ · Apr 10th, 2002, 10:58 AM

Has your calculation been set to Manual?
(Under Tools>Options)

Jay Petrulis · Apr 10th, 2002, 11:00 AM

Hi,

Don't have XP, but make sure your calculation setting is turned to automatic.

Tools>Options>Calculation

If you want to keep it on manual, F9 will recalculate, Ctrl+Alt+F9 will force a full recalculation.

HTH,
Jay

tornadowatch · Apr 10th, 2002, 11:04 AM

Thanks, that was easy. But, I never changed it to that and no one else gets on this computer. Is it possible for it just to change like that? I guess anything is possible, thanks again.

Mark W. · Apr 10th, 2002, 11:07 AM

Quote:

On 2002-04-10 10:04, tornadowatch wrote:
Thanks, that was easy. But, I never changed it to that and no one else gets on this computer. Is it possible for it just to change like that? I guess anything is possible, thanks again.

The 1st workbook opened establishes the Calculation setting for all subsequently opened workbooks. Is it possible that you opened someone else's workbook that was previously saved with Calculation set to Manual?

[ This Message was edited by: Mark W. on 2002-04-10 10:08 ]

tornadowatch · Apr 10th, 2002, 11:17 AM

Very possible, a shared file on the server perhaps. However, I haven't had this happen before. Something new with XP?

Mark W. · Apr 10th, 2002, 11:18 AM

Quote:

On 2002-04-10 10:17, tornadowatch wrote:
Very possible, a shared file on the server perhaps. However, I haven't had this happen before. Something new with XP?

Nope, always been that way!

tornadowatch · Apr 10th, 2002, 11:23 AM

Think I know the problem. Someone new is entering data in the shared file and must have changed the calculation to manual. He just started a few weeks ago. Shortly after that is when my problem began. Thanks again to everyone for the help.

Jay Petrulis · Apr 10th, 2002, 12:06 PM

Quote:

On 2002-04-10 10:23, tornadowatch wrote:
Think I know the problem. Someone new is entering data in the shared file and must have changed the calculation to manual. He just started a few weeks ago. Shortly after that is when my problem began. Thanks again to everyone for the help.

Sure, blame the new guy!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 10:57 AM	#1
tornadowatch New Member Join Date: Apr 2002 Posts: 4	I have been using excel in XP Pro. Edition for several months. Just recently when I enter new data in the cells, the result does not change. The formula is correct but doesn't work. I can enter the exact same formula back in the cell and it works fine, but will not update when numbers in the cells are changed. What the heck is up with that?

Apr 10th, 2002, 10:58 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Has your calculation been set to Manual? (Under Tools>Options)

Apr 10th, 2002, 11:00 AM	#3
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, Don't have XP, but make sure your calculation setting is turned to automatic. Tools>Options>Calculation If you want to keep it on manual, F9 will recalculate, Ctrl+Alt+F9 will force a full recalculation. HTH, Jay

Apr 10th, 2002, 11:04 AM	#4
tornadowatch New Member Join Date: Apr 2002 Posts: 4	Thanks, that was easy. But, I never changed it to that and no one else gets on this computer. Is it possible for it just to change like that? I guess anything is possible, thanks again.

Apr 10th, 2002, 11:17 AM	#6
tornadowatch New Member Join Date: Apr 2002 Posts: 4	Very possible, a shared file on the server perhaps. However, I haven't had this happen before. Something new with XP?

Apr 10th, 2002, 11:23 AM	#8
tornadowatch New Member Join Date: Apr 2002 Posts: 4	Think I know the problem. Someone new is entering data in the shared file and must have changed the calculation to manual. He just started a few weeks ago. Shortly after that is when my problem began. Thanks again to everyone for the help.