Excel workbook crashed

[Edgar Thoemmes]

Hi

I was happily working away on a workbook yesterday when I tried to use a
conditional formatting on a rather large range. This caused the workbook to
crash and now when ever I open it the workbook gets stuck and won't load
completely. Does anyone know of anyway opening the book with calculating, or
any other measure that might enable me to open the workbook.

I am using excel 97 on windows nt platform.

TIA

 

[Max]

Does anyone know of anyway opening the book with [out?]

calculating, ...

Presume you mean open with calculation set to manual?

Try opening Excel an empty book first
Switch the calc mode to manual via:
Tools > Options > Calculation tab > Manual > OK

Then open your book in this same Excel session
via say File > Open

The prevailing calc mode i.e. Manual, will be applied on your book.

 

[Edgar Thoemmes]

Hi

I tried this method and the workbook still won't open. Is there a way you
can open Excel in 'safe mode'?

Thanks

 

[Max]

I tried this method and the workbook still won't open.
Is there a way you can open Excel in 'safe mode'?

Try some of the hits in this googling result:
http://tinyurl.com/4erjp