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?
By the way, my method of answering these questions is generally more about educating the person asking the question rather than just giving an answer which may or may not precisely fit the individual's
The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option
David Miller (dlmille)
Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…