Link to home
Start Free TrialLog in
Avatar of JesusFreak42

asked on

Corrupted Excel Spreadsheet

Hello All,
    We have   a rather large spreadsheet we have been using for over a year now. We have been Co-Authoring it on an Office 365 SharePoint site. Everything has been working great, until last week. All of a sudden, last week the message "cannot open the workbook selected. it is an unsupported file format" popped up and kicked me out of the file. It was then unable to be opened. We replaced the online version with a slightly dated (by hours) local version. It worked fine at first, but then threw the same error. Then, after several attempts at replacing the file, the error changed to the below images:
User generated imageUser generated imageUser generated image
I followed the prompts. Below is also the text to the results of the repair the file:

Errors were detected in file ' Documents/WOUNDCARE UPDATE.xlsx'

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.

Repaired Part: /xl/worksheets/sheet1.xml part with XML error.  Load error. Line 2, column 0.

This seemed to repair the file as it began functioning normally. But then it crashed again when we were using the file. I ran the repair again with the same results as above, but I obviously have not gotten to the heart of the issue.

Can someone tell me what is happening and how to fix it in a step by step manner?

P.S. I cannot attach the actual file as it contains some medical information covered by HIPAA
Avatar of redmondb
Flag of Afghanistan image

Hi, JesusFreak42.

There are a number of possibilities. My main thought is that the file has had some corruption which it managed to cope with. However, it has now passed a threshold and so is constantly failing.

If that's the situation then you will need to do a manual rebuild of the file. Depending on the structure of the file, this could be a big exercise.

I appreciate that the data is highly confidential, but could you delete all the data from a working version (ideally the "slightly dated" one) and post it here, please?

Also, how big is the live file?

Avatar of JesusFreak42


Here it is with all the data removed. I did have to run through the prompts above to get this file to open. In general, it is between 3MB and 10MB in size.

Thanks. It doesn't seem like a complicated file so I recommend that you completely rebuild the file. I would do the following...
(A) Copy all cells from each sheet and paste the values, formatting and column widths into a sheet in a new file - but not formulas. (Note: It's not enough to simply copy whole sheets - you need to copy cells.)
(B) Create the required Names in the new file.
(C) Create the required formulas in the new file.

I'm sure I left some items out (Row Heights for one), but that should at least get you started.

Finally, the sheets still have a "memory" of the cells used (NOT the data!) - how did you delete the data?

Some of the rows I deleted, others I selected the cells and pressed Delete.
Avatar of redmondb
Flag of Afghanistan image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The primary user did an older recovery and it seems to be working. I told her that if this one fails, to proceed with a rebuild. I'll keep you updated!
Thanks, JesusFreak42.
The entire spreadsheet needed to be rebuilt. It was corrupted.
Thanks for the update JesusFreak42.

I don't know whether it's a strength or a weakness of Excel files that they can carry on for a long time without manifesting a corruption..
 - The strength is that they don't fall down dead at the first sign of a problem. It wouldn't surprise me if most files with some corruption actually survived without error until they were finished with.
 - The weakness is that when they finally die, you may have to go back a long way to find a clean version - with no guarantee that you've found one. Also, "somewhat" corrupt files can be very sensitive to the version of Excel you open them with. (And I'm convinced that corruption can spread to other files, although I've never proved this to my own satisfaction.)