Excel - map lost when copying worksheet containing XML Maps to a separate file
Posted on 2013-12-11
I have an Excel file with a set of XML Maps defined on a worksheet in Excel 2007.
I would like to copy this worksheet out into different workbooks and have the XML Map be retained. Currently the copied worksheet is completely blank for XML maps after the move; and I've tried using the Exporting as XML feature on the developer tab and seems to just export the worksheet data itself in an XML format vs exporting the XML Maps.
Is there any way to do this without manually remapping in the new workbook?