Cannot open file...

jcphoffman

New Member
Joined
Sep 19, 2002
Messages
1
I have an excel file which I am trying to open. I use it many times every day, but now when I try to open it:
1. A small "Microsoft Excel" window appears saying "File error: data may have been lost".
2. When I click on "OK" (the only choice) the file continues trying to open and "[Group]" appears after the file name in the blue bar at the top of the excel window.
3. The "update automatic links" window appears (the file contains external links to 2 other workbooks).
4. Whether I click "Yes" or "No" to update links, it then continues to try opening, then brings up a "Program Error" window saying "EXCEL.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created."
5. That's it - can't even open the file to make any changes....can you help at all? Maybe figure otu a way to open it?
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

manney

New Member
Joined
Mar 25, 2002
Messages
46
There are several Excel file repair utilities available on the Internet (search for Excel File Repair). There are also companies who will do the repair for you and charge you on a per-case basis.

MS Access 2000 will sometimes be able to open an Excel workbook and get at the data, so will Word (oddly enough). Link to the spreadsheet under Excel, and open the file under "Recover text from any file" under Word.

Good luck. Back up your files daily!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,216
Messages
5,594,886
Members
413,947
Latest member
gizmolucy

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