manual vs automatic calculation

tandrea · Apr 25th, 2002, 02:55 PM

I have several excel workbooks that are linked together by various formulas. The formulas are suppose to calculate automatically, however, occasionally all of the linked workbooks switch to manual calculation. I know how to reset the workbooks to automatically calulate but I would like to know what is causing the workbooks to switch so I can prevent it in the future.

Thanks,
Tracey

Mark W. · Apr 25th, 2002, 03:02 PM

The calculation mode of the 1st workbook opened establishes the calculation mode for subsequently opened workbooks.

[ This Message was edited by: Mark W. on 2002-04-25 14:03 ]

Jay Petrulis · Apr 25th, 2002, 03:15 PM

Hi,

In addition to what Mark stated, I have a number of workbooks which change the calc setting to manual on opening.

So, you can also check the workbook events to see if anything changes the setting.

Bye,
Jay

Jack in the UK · Apr 25th, 2002, 03:18 PM

personally i HATE auto, it drives me NUTS Bonkers even, ALWAYS Manula.. i like to control Excel untill she shows us her magic we cant live without

hit F9 and she calculatet with easy...

TOP TIP.

Igf heavy shopping shes carryiny i make her coffe and let her add aways, and she by far the best looker in my office.

Most of all she loves me ..... ah XX

Apr 25th, 2002, 03:18 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	personally i HATE auto, it drives me NUTS Bonkers even, ALWAYS Manula.. i like to control Excel untill she shows us her magic we cant live without hit F9 and she calculatet with easy... TOP TIP. Igf heavy shopping shes carryiny i make her coffe and let her add aways, and she by far the best looker in my office. Most of all she loves me ..... ah XX __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

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

Apr 25th, 2002, 02:55 PM	#1
tandrea New Member Join Date: Apr 2002 Posts: 27	I have several excel workbooks that are linked together by various formulas. The formulas are suppose to calculate automatically, however, occasionally all of the linked workbooks switch to manual calculation. I know how to reset the workbooks to automatically calulate but I would like to know what is causing the workbooks to switch so I can prevent it in the future. Thanks, Tracey

Apr 25th, 2002, 03:02 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	The calculation mode of the 1st workbook opened establishes the calculation mode for subsequently opened workbooks. [ This Message was edited by: Mark W. on 2002-04-25 14:03 ]

Apr 25th, 2002, 03:15 PM	#3
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, In addition to what Mark stated, I have a number of workbooks which change the calc setting to manual on opening. So, you can also check the workbook events to see if anything changes the setting. Bye, Jay