Excel 2002 Settings when Crashing

[Guest]

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.

 

[Gord Dibben]

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

For all new workbooks you could set up a Template with Autorecovery disabled
through Tools>Options>Save.

Open a new workbook, make your settings then File>Save As>File Type>MS 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 File>New
Workbooks.

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


Gord Dibben Excel MVP

 

[Guest]

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]

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