locked
Error during open the excel sheet RRS feed

  • Question

  • When i open the excel sheet, i am getting following popup, so i compare two excel file(with errro popup, without error popup), so i got below(screen short2), but i could not able to find exact error and which field causing error, so can any one help me to solve this issue.

    Screen Short1:

    Screen Short2:

    Tuesday, September 23, 2014 1:48 PM

Answers

  • You can try to validate that corrupted excel file using Open XML SDK productivity tool. There is a Validate button on the screenshot 2, you have posted.

    If that fails (the tool won't show any errors), the next step is to examine calcChain.xml and sheet1.xml parts manually. Most likely there are broken or missing references. But you have to be familiar with the Open XML file format documentation to accomplish that.

    Regards,

    Michael

    Tuesday, September 23, 2014 10:05 PM