Is it possible to set XL up so that when it crashes

In the "Microsoft has encountered a problem and needs to close ..........."
dialog

the checkbox "Recover my work and restart Microsoft Excel" is unchecked by
default.

Autorecovery is enabled/disabled on a workbook basis, not application.

For all new workbooks you could set up a Template with Autorecovery disabled
through ToolsOptionsSave.

Open a new workbook, make your settings then FileSave AsFile TypeMS Excel
Template(*.xlt).

Name it BOOK and let Excel add the .xlt extension.

Store this in your XLSTART folder and it will be the Template for all FileNew
Workbooks.

Existing workbooks will have to be reset manually and re-saved.


Gord Dibben Excel MVP

On Wed, 20 Apr 2005 01:44:01 -0700, srparr
wrote:

Is it possible to set XL up so that when it crashes

In the "Microsoft has encountered a problem and needs to close ..........."
dialog

the checkbox "Recover my work and restart Microsoft Excel" is unchecked by
default.

Thanks Gord,

But we have already set the disable autorecovery properties on all workbooks
& Book.xlt 's to true, but when XL crashes the default, on our build anyway,
is that the checkbox "Recover my work and restart Microsoft Excel" is checked.

An alternatively solution maybe - is it possible to prevent the "Microsoft
Excel has encountered a problem and needs to close ..........." dialog from
showing at all ?

thanks

stuart

"Gord Dibben" wrote:

Autorecovery is enabled/disabled on a workbook basis, not application.

For all new workbooks you could set up a Template with Autorecovery disabled
through ToolsOptionsSave.

Open a new workbook, make your settings then FileSave AsFile TypeMS Excel
Template(*.xlt).

Name it BOOK and let Excel add the .xlt extension.

Store this in your XLSTART folder and it will be the Template for all FileNew
Workbooks.

Existing workbooks will have to be reset manually and re-saved.


Gord Dibben Excel MVP

On Wed, 20 Apr 2005 01:44:01 -0700, srparr
wrote:

Is it possible to set XL up so that when it crashes

In the "Microsoft has encountered a problem and needs to close ..........."
dialog

the checkbox "Recover my work and restart Microsoft Excel" is unchecked by
default.

Don't know.

Maybe a registry issue.

I'll fool around with it and see if anything can be done. Will get back
later.

Tee-time in 40 minutes.


Gord

On Thu, 21 Apr 2005 01:05:01 -0700, srparr
wrote:

Thanks Gord,

But we have already set the disable autorecovery properties on all workbooks
& Book.xlt 's to true, but when XL crashes the default, on our build anyway,
is that the checkbox "Recover my work and restart Microsoft Excel" is checked.

An alternatively solution maybe - is it possible to prevent the "Microsoft
Excel has encountered a problem and needs to close ..........." dialog from
showing at all ?

thanks

stuart

"Gord Dibben" wrote:

Autorecovery is enabled/disabled on a workbook basis, not application.

For all new workbooks you could set up a Template with Autorecovery disabled
through ToolsOptionsSave.

Open a new workbook, make your settings then FileSave AsFile TypeMS Excel
Template(*.xlt).

Name it BOOK and let Excel add the .xlt extension.

Store this in your XLSTART folder and it will be the Template for all FileNew
Workbooks.

Existing workbooks will have to be reset manually and re-saved.


Gord Dibben Excel MVP

On Wed, 20 Apr 2005 01:44:01 -0700, srparr
wrote:

Is it possible to set XL up so that when it crashes

In the "Microsoft has encountered a problem and needs to close ..........."
dialog

the checkbox "Recover my work and restart Microsoft Excel" is unchecked by
default.