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

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

GraH

Well-known Member
Joined
Mar 22, 2020
Messages
1,273
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Files do get corrupted. Do you have any backups?
Can you restore to an early enough version that does not generate the error message?
 

bkeat

New Member
Joined
Jan 2, 2013
Messages
22
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.
 

Forum statistics

Threads
1,181,081
Messages
5,927,970
Members
436,581
Latest member
Luceroso

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