Share via

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

Anonymous
2017-01-19T03:35:50+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2017-03-15T10:46:17+00:00

    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

    13 people found this answer helpful.
    0 comments

9 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-02-17T09:25:03+00:00

    Dear Ma.Lau,

    Even i am also facing same issue with my excel. 

    There is column where we store comments in XML format. This is causing us the issue.

    How we can solve?? Need you help

    0 comments