Posted to microsoft.public.excel.programming

mike

external usenet poster

Posts: 216

Forcing Automatic Calculation

Hi All,
I can't seem to get my excel files to keep the
automatic calculation turned on- on more than one
workboot. Every day I have to re-enable it. How can I get
the Auto calculation to turn on in each workbook every
time they load? I'm guessing it would go in each
workbook's open event, but I'm not sure of the syntax.

Thanks,
Mike

Excel 2000
Windows 2000

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatic calculation	BeckyW	Excel Worksheet Functions	1	October 8th 07 09:59 AM
Automatic Calculation	JennyZurb	Excel Discussion (Misc queries)	2	December 22nd 05 01:00 PM
Automatic Calculation	raweber	Excel Discussion (Misc queries)	0	August 22nd 05 08:31 PM
forcing complete calculation	Claude	Excel Programming	6	October 21st 03 07:17 PM
range.calculation with UDF not working when calculation is set to automatic	Brian Murphy	Excel Programming	5	October 14th 03 07:02 PM

All times are GMT +1. The time now is 07:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us