What does denormalized data in Excel means

[SirName]

I am not an expert in Excel, but I opened an XML file in Excel, and modified and now I'm trying to export it out. However it is telling me that: ____ is not exportable because it contains the following: Denormalized data. I do not understand what the above is telling me. Can someone give me a quick guide on what's wrong.

[Leanne]

In a database, "normalized" data has been associated with data identifiers that are used to link it to other database records. For instance, if you had an account with an online retailer, they would link your account number (an identifier unique to you) to your name / address / phone data, and link the account number with your purchases. So if you bought an item that later was recalled for some reason, they could write a query that creates a name and address list of all the people that bought that item.

I am not familiar with XML, but it sounds like you modified the data in such a way that unique identifiers were dis-associated from their data records. You *may* be able to work around this by saving the file in an Excel format rather than in an XML format; or you might save the file in comma separated value (CSV) format and re-import it
into Excel.

[Koman]

Read the following topic : "When I export XML data, a message tells me that the XML maps in my workbook are not exportable". This is a kind of error and you might need to read the troubleshooting reference given below.

Troubleshoot XML