Excel Issue: We found a problem with some content in excel

[RahulNarang1]

Hello All,

I am using a large excel workbook (10K Records) for my automation. I run around 1K records daily and update the original spreadsheet after the day's run using "Data OLEDB Object" . Some how the Excel file get corrupted and I am unable to use it after that. 
The error which I get is "We found a problem with some content in x.xlsx. Do you want us to recover"

If I recover it, I still loose the data. In the logs I found this error. 
"/xl/worksheets/sheet1.xml part with XML error. A document must contain exactly one root element. Line 1, column 0"

Any work around this. How to fix this issue. Would really appreciate your help?

------------------------------
Rahul Narang
------------------------------

[hossein.azimi]

Hi Rahul,

It looks like the issue related to the Excel application and transfers to the Blue Prism. Please look at this web site; It may help with the issue.

https://www.systoolsgroup.com/updates/fix-we-found-a-problem-with-some-content-in-excel-error/
http://www.repairmsexcel.com/blog/resolve-excel-2013-content-error

Regards

------------------------------
Hossein Azimi
Customer Support Engineer, APAC
Blue Prism
Sydney NSW
------------------------------