Microsoft Excel error has occurred

Asked By ChristopherVBrown 20 points N/A Posted on - 03/07/2013

 

While using Microsoft Excel, I went for saving data and exporting it. But it shows me the error like the one in the screenshot. Can anyone please explain the issue and solve it please?

 

“Microsoft Excel

Cannot save or export XML data. The XML maps in this workbook are not exportable.”

• Status: Open
• Question Views: 770
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Lynda M Harvey 0 points N/A #171086

Microsoft Excel error has occurred

 

 

  Hi Christopher,

XML mapping cannot be exported if it contains one of the following XML schema constructs:

·          List of lists    One list of items contains a second list of items.

·          Denormalized data    An XML list contains an element that has been defined in the schema to occur

once (the maxoccurs attribute is set to 1). When you add such an element to an XML list, Excel fills the list column with multiple instances of the element.

·          Choice  :  A mapped element is part of a <choice> schema construct.

 

Excel does not import the XML data properly ( for an immediate export.. You will need to adjust it before you can export it.  It needs to be set up a little bit further before you can export it. You don't need to do it every single time. There is a link on the bottom of the XML source task pane.  Verify Map for Export.  You can click on that. If it says denormalized data. It is not good.  If it says your map is exportable  then you have it..

 

 

About Lynda M Harvey

Questions
7

Answers
66

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 03/16/2013
• Question Category: MS Excel