Automatic Calculation changed to Manual

arnybarn · May 10th, 2002, 09:41 AM

Out of no where my default calculation setting has been changed to Manual when I open a new workbook.
I can change individual workbooks back to automatic - but want my default to be reset to automatic.
Can you help?
Thanks,

NateO · May 10th, 2002, 09:50 AM

Go to your menu, tools->options->calculation, click the automatic option.

Sounds like someone wrote some sloppy code, not returning your setting when complete...

arnybarn · May 10th, 2002, 09:58 AM

Thanks Nate -
I have tried that and it does keep individual workbooks as automatic - but when I close Excel and re-open it the blank "Book1" is reset back to Manual.

So I may have a file somewhere that is causing this to happen in the background?

May 10th, 2002, 09:50 AM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Go to your menu, tools->options->calculation, click the automatic option. Sounds like someone wrote some sloppy code, not returning your setting when complete... __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

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

May 10th, 2002, 09:41 AM	#1
arnybarn New Member Join Date: May 2002 Location: Dave Posts: 2	Out of no where my default calculation setting has been changed to Manual when I open a new workbook. I can change individual workbooks back to automatic - but want my default to be reset to automatic. Can you help? Thanks,

May 10th, 2002, 09:58 AM	#3
arnybarn New Member Join Date: May 2002 Location: Dave Posts: 2	Thanks Nate - I have tried that and it does keep individual workbooks as automatic - but when I close Excel and re-open it the blank "Book1" is reset back to Manual. So I may have a file somewhere that is causing this to happen in the background?