/xl/sharedStrings.xml part with XML error.(Strings) Unexpected end of input.

Question

Hello, Can you help me with this problem of Excel2013.

First, I want to open an Excel file. But it appeared this problem:

And I clicked 'YES' but it appeared this:

And after this, some of my content was blank, and some was existed.

Plz help me with this problem, I want to open this file completely.

Thanks.

Answer 1

Hi, 

You can rename the XLSX file to ZIP extension, then decompress the zip file.

Go to the /xl/sharedStrings.xml and check the line and column showed in the error message. Probably there is an strange character that Excel dont recognise. 

You also can check encoding at the head of the file and try with other encodings: 

<?xml version="1.0" encoding="UTF-8"?>

<?xml version="1.0" encoding="UTF-16"?>

<?xml version="1.0" encoding="iso-8859-1"?>

<?xml version="1.0" encoding="windows-1252"?>

etc.

When you have deleted the strange character (or changed the encoding), you can save the file, compress again to ZIP and rename it to XLSX. 

Regards, 

Juan Miguel

Answer 2

Hello Jackson,

For better assistance, we would like to know more information about your concern.

• What is the error that you get when you try to open an Excel file?
• Where does the file come from? Did you receive it as an attachment?
• Does the issue occur only on a specific Excel file?

Kindly attach the image that you see upon opening the Excel file.

Your reply is most important for us to ensure we assist you accordingly.

Regards.

Answer 3

Sorry, I don't know why the pics can not display.

When I open the excel file, it shows:

'We found a problem with some content in 'my excel file.xlsx', do you want to recover as much as we can? If you trust the source of this workbook, click yes'.

And I click 'yes', it popped window and said:

'removed part:/xl/sharedStrings.xml part with XML error. (Strings)Unexpected end of input. Line 43, Column 102. Removed Records:...'.

This excel file is not an attachment.

Yes, this issue occurs only on this Excel file.

About the Chinese words, they are just file name.

Answer 4

With regard to your concern, you can try to create a copy of the file, rename the new file and then try to launch it. You can also send a copy of the file to a friend or open the file using a different device. This can help us isolate the issue.

We'll be for your update.

Regards.

Answer 5

Thank you for your help but it still dosen't work.

Firstly, I have tried to create a new copy of the file, and Ihave renamed it, but it still occurs the same problem.

Secondly, I have sent to three different computers by email and I tried to open it with Excel2003, but it didn't work.

I guess maybe there are some problem with the file - 'sharedStrings.xml', but I have no idea how to fix it.