OT: Can anyone help me with this Excel problem??!!

[Slick]

I came across a similar problem a couple of years (and maybe Versions) ago and I ended up checking the microsoft website. I found that for my particular problem, there was a known bug that would prevent me from ever opening my file again and there was not a good fix. There was a band-aid solution that would transfer data but not all the charts, etc.:

This is similar to what geo mentions above.

Create a new workbook file. In cell A1 link it to cell A1 in the other file. Then copy this to all cells in all sheets. This will link each cell in the new workbook with its corresponding cell in the broken file without ever needing to open the file as a whole. Next, copy all cells and, using "paste special", paste "values" or "formulas" as you see fit. This will convert the links to real values/formulas. You will probably have to do this on a sheet by sheet basis.

You will lose charts and a lot of other things this way but you will be able to at least save data.

Hope this might help.

Slick.