ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   autocalc to complicated to turn off (https://www.excelbanter.com/setting-up-configuration-excel/62217-autocalc-complicated-turn-off.html)

lasse

autocalc to complicated to turn off
 
Please make it better in office 12 to turn off autocalc.
At the moment it is a pain in the bXXX

I managed to get it working for new Excel 2003 sessions but then I get no
Sheet1.

Lars

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup

Ken Wright

autocalc to complicated to turn off
 
I would suggest the vast majority of people would not want it turned off
ever, and there are enough people that have a problem with it switching to
manual when they don't want it to as it is.

It takes only a few seconds to switch to manual though, so what exactly are
you having a problem with:-

Tools / Options / Calculation Tab / Tick Manual and hit OK?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"lasse" wrote in message
...
Please make it better in office 12 to turn off autocalc.
At the moment it is a pain in the bXXX

I managed to get it working for new Excel 2003 sessions but then I get no
Sheet1.

Lars

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup




lasse

autocalc to complicated to turn off
 
Ken

The problem is that I want to to be turned of permanently when Excel start up.
This is a little bit complicated at the moment.

I am using Excel for monte carlo simulations in an Investement bank for
pricing exotic derivatives.

Lars

"Ken Wright" wrote:

I would suggest the vast majority of people would not want it turned off
ever, and there are enough people that have a problem with it switching to
manual when they don't want it to as it is.

It takes only a few seconds to switch to manual though, so what exactly are
you having a problem with:-

Tools / Options / Calculation Tab / Tick Manual and hit OK?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------


"lasse" wrote in message
...
Please make it better in office 12 to turn off autocalc.
At the moment it is a pain in the bXXX

I managed to get it working for new Excel 2003 sessions but then I get no
Sheet1.

Lars

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup






All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com