There are others solutions that are supposed to be able to open
corrupted files, but most of them only allow access to your
formulas or data.
If you have a "later" version of XL then the File | Open dialog box
has an option to "open and repair". You just have to find it.
In the dialog box, adjacent to the Open button in the bottom right
corner is a "down" arrow. Click that to show the open and repair option.

I've read that opening an Excel file from Word Pad can sometimes
allow you to get your data and code.
Also, you could try Star Office or Open Office to open the file.
They seem to be able to handle corrupted files better than XL..
I've found XL modules are viewable in my 5.2 version of Star Office.

Regards,
Jim Cone
San Francisco, USA



"Anthony" <Anthony@discussions.microsoft.com> wrote in message
news:815C65A6-F621-4621-BAB8-878A9E0D14E9@microsoft.com...
Jim,
thanks for your 'sensible' answer - but your suggestions din't work
any other ideas??
many thanks

"Jim Cone" wrote:

> Anthony,
> Couple of things to try, no guarantees.
> 1.Delete your toolbar file (Excel10.xlb in xl2002), it is automatically rebuilt
> when xl opens. Probably best to open another file first and uncheck
> all add-ins in Tools | Add-ins then close xl and delete the file.
> 2. Press the Shift key while opening the file. This disables macros.
> Jim Cone
> San Francisco, USA
>
>
> "Anthony" <Anthony@discussions.microsoft.com> wrote in message
> news:A7EF12EE-64D6-48C8-AC69-ECFD458C4B78@microsoft.com...
> Hi,
> Having spent most of yesterday putting together my own excel workbook and am
> a little gutted this morning to find I can't get into it.
> The file will open but as soon as it does it freezes (egg timer thingy) and
> after a minute or so I get the replt - excel not responding!
> I have run a virus check, cleared all my cookies and completed a system
> restore all of which did not work.
> Thr workbook contains around 10 worksheets, a personal toolbar and around 20
> macros all of which carry out various things.
>
> I can get into any other excel workbook I have - but not this one ??
> I can't even get into the VB editor (ALT+F11) to remove the code and/or
> macros.
> Can any body offer any solutions - before I beat up the cat !!!!! (joke)
>