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

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.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Edgar Thoemmes" wrote in message
...
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

Hi

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

Thanks

"Edgar Thoemmes" wrote:

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

"Edgar Thoemmes" wrote:
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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----