<div>
CTRL++END goes to the last cell with data in it (B482).<br />
<br />
Copying the data to another worksheet and applying my &quot;map&quot; file to it worked.<br />
<br />
Any idea why the original worksheet didn't work? Having to remap when this happens is a bit of a pain.<br />
<br />
Thanks for the help,<br />
Sid
</div>


CTRL++END goes to the last cell with data in it (B482).

Copying the data to another worksheet and applying my "map" file to it worked.

Any idea why the original worksheet didn't work? Having to remap when this happens is a bit of a pain.

Thanks for the help,
Sid

<div>
This some times happens when data is altered; Excel keeps a range with active cells and that occasionally gets messed up. However you have a good chance this does not occur again..<br />
Glad we could help you fix it.
</div>


This some times happens when data is altered; Excel keeps a range with active cells and that occasionally gets messed up. However you have a good chance this does not occur again..
Glad we could help you fix it.

<div>
<div class="content wysiwyg-content">
I have an Excel worksheet that I use to generate an XML file. It is a worksheet that has worked well in the past. When I tried to export today, after editing the worksheet, Excel exports 65K XML elements, there are only 400+ rows of data on the worksheet. Previously it exported only those rows with data, now there are thousands of empty XML elements.<br />
<br />
I would appreciate any insight into how to fix this. As a work-around I manually delete the empty XML elements, but I would like the export to work.<br />
<br />
Thanks,<br />
Sid
</div>
</div>


I have an Excel worksheet that I use to generate an XML file. It is a worksheet that has worked well in the past. When I tried to export today, after editing the worksheet, Excel exports 65K XML elements, there are only 400+ rows of data on the worksheet. Previously it exported only those rows with data, now there are thousands of empty XML elements.

I would appreciate any insight into how to fix this. As a work-around I manually delete the empty XML elements, but I would like the export to work.

Thanks,
Sid

Issue exporting to XML with Excel 2016

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).