Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Excel 2007- XML maps in my workbook are not exportable
Hello: I exported an xml file from an application called Wall Street Office (microsoft sql-based). I have just installed Microsoft Excel 2007 where I can select Developer & import the XML file. I was testing the export functionality & have not made any updates. When I click on export on the Developer tab, it gives me this message: "XML maps in my workbook are not exportable." I click on Help & all that information is foreign language to decipher what i need to do. Can you help me? This is for a work project. thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Excel 2007- XML maps in my workbook are not exportable
Furthermo When i select Source/ "Verify Map for Export": it states [["Denormalized data. A mapped element's relationship with other elements cannot be preserved"]]. This is disappointing because I assume if you can import than you can export the XML. How can I fix this? Thanks. Microsoft Help states: Denormalized data An XML table 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 table, Excel fills the table column with multiple instances of the element. "biz7" wrote: Hello: I exported an xml file from an application called Wall Street Office (microsoft sql-based). I have just installed Microsoft Excel 2007 where I can select Developer & import the XML file. I was testing the export functionality & have not made any updates. When I click on export on the Developer tab, it gives me this message: "XML maps in my workbook are not exportable." I click on Help & all that information is foreign language to decipher what i need to do. Can you help me? This is for a work project. thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft 2007 Excel - Share Workbook Error | Excel Discussion (Misc queries) | |||
Microsoft Excel 2007 + DBF | Excel Discussion (Misc queries) | |||
Is excel mailing list exportable to Outlook Contacts? | Excel Discussion (Misc queries) | |||
Can a cell defined by a formula become an exportable numeric valu. | Excel Worksheet Functions | |||
Automatically refresh XML Maps when opening a workbook | Excel Discussion (Misc queries) |