File won't open

Dr_Worm

Board Regular
Joined
Jul 28, 2003
Messages
103
We are having a problem at work, the project managers create huge excel file with lots of formulas and links, etc. Every now and then one gets too big and when opening we get the message “This program has performed an illegal operation and will be shut down”. All we need to do is restore the back up from the previous night and split the file into two. We’ve tried to educate people on this matter, and it doesn’t happen too often.

At the moment I have a file that I can’t open because of this, and I don’t know when it was last modified, backups are only a week old and the oldest backup can’t be opened. I’ve tried running excel in safe mode, but that doesn’t help. :oops:

Is there a way to open this file? Runnig Excel 97 on Windows 98se.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

dk

MrExcel MVP
Joined
Feb 15, 2002
Messages
2,942
Hi,

You could try and use one of the Open Office products to open the spreadsheet. Go to the Open Office Website and download the software (it's free). Also, if you know anyone with Excel XP or Excel 2003 then you can see if they can open it (those versions apparently have better recovery mechanisms than older versions of Excel).

There are also companies that specialise in recovering corrupted documents. A quick Google search should reveal plenty.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,096
Messages
5,768,068
Members
425,451
Latest member
JohnBrooksBiddle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top