Finance | Project Operations, Human Resources, ...

excel error, while opening excel file

(0) Share

Report

Posted on by @rp@n

Hi all,

I have generated a report Accured Purchase AX 2012 R3 . It is successfully generated then we save the report in excel. It's saved but when trying to open the excel, we got below error.

Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Illegal xml character. Line 163, column 10296.

Kindly let me know how will resolve this.

Thnaks!

All responses (3)

Answers (0)

Suggested answer

ergun sahin 8,816 Moderator on at

Like (0)

Report

RE: excel error, while opening excel file

Obviously it's a character issue. If there is a certain character, changing it is a solution, but if there is no certain suspect and since you cannot change all the characters, you can find the troublesome character by examining the office side.

But as I said, it is very unlikely that you will find that information in this cominity.

Have you tried the instructions in the link I sent? I recommend you to try especially with utf-8.
@rp@n 6 on at

Like (0)

Report

RE: excel error, while opening excel file

thanks Ergun,

In the report, we have one column item name. That is in to Chinese character. I believe some special character is there and that is not recognized by excel. t

let me check
Suggested answer

ergun sahin 8,816 Moderator on at

Like (0)

Report

RE: excel error, while opening excel file

The error is not directly related to ax. If there is no one who encounters the same error, you don't have much chance to find a solution here. It would be useful to have a look at the ms office sites.

answers.microsoft.com/.../121f48d7-2468-4d39-8a47-76ca1ce652aa