disabling automatic calculations during automation session

[Brian]

I am inserting a new worksheet in a very large spreadsheet that does a lot of
computations. When I close/save the spreadsheet it takes an extremely long
time which I have tracked down to the fact that it is doing calculations
automatically before save (tools->options->calculation tab). Does anyone know
if there is any way to set the calculation to manual and uncheck the
"recalculate before save" option prior to saving the spreadsheet in order to
speed things up.

Thanks.

 

[Cindy M.]

Hi =?Utf-8?B?QnJpYW4=?=,

I am inserting a new worksheet in a very large spreadsheet that does a lot of
computations. When I close/save the spreadsheet it takes an extremely long
time which I have tracked down to the fact that it is doing calculations
automatically before save (tools->options->calculation tab). Does anyone know
if there is any way to set the calculation to manual and uncheck the
"recalculate before save" option prior to saving the spreadsheet in order to
speed things up.

Since you haven't received a response here, try asking in the excel.programming
newsgroup, where you'll find many more people who specialize in Excel.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail