Excel opening file - found a problem with content

bkeat

New Member
Joined
Jan 2, 2013
Messages
22
Hello friends,

I have a big problem with one of my files. When opening its giving a warning
1656739514761.png

If I click NO the files closes and does not open.
If i click YES it performs a repair and after 5 minutes the below message appears.

1656739565832.png


Once the file opens it open with no content.

The file size is 83MB.
I tried to open in PDF, tried to restore previous versions and tried saving.
I am doing much googling without success.

Does anyone have any suggestions what I could do to recover this file?

The error log

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error159200_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\user\Downloads\exceptions list.XLSX'</summary><additionalInfo><info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info></additionalInfo><removedParts><removedPart>Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Unexpected end of input. Line 2, column 729074637.</removedPart><removedPart>Removed Part: Data store.</removedPart></removedParts></recoveryLog>
 
Last edited:

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Files do get corrupted. Do you have any backups?
Can you restore to an early enough version that does not generate the error message?
 
Upvote 0
Files do get corrupted. Do you have any backups?
Can you restore to an early enough version that does not generate the error message?
The backups I have contain the same issue and there is no previous versions available.
I tried to open in repair mode and others with out success.
 
Upvote 0

Forum statistics

Threads
1,223,910
Messages
6,175,316
Members
452,634
Latest member
cpostell

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
Back
Top