ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cannot map XML Source to excel workbook (https://www.excelbanter.com/excel-discussion-misc-queries/151270-cannot-map-xml-source-excel-workbook.html)

jtwoods4, MCP

Cannot map XML Source to excel workbook
 
am trying to map an XML data source to my excel workbook. THis is done in
excel by going to the Data menu -- XML -- XML Source. I then try to drag an
XML element from the selected source to the excel column header. Normally
this will map the element to that column in the excel workbook. However, I
tried to do this today and recived the following error.

"The operation cannot be completed because the result would overlap an
external data range or PivotTable"
Has anyone seen this before?



All times are GMT +1. The time now is 07:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com