Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Converting Excel list to XML (Excel 2003)

    I am trying to get a list of people that is in an Excel spreadsheet to export to a XML file. I have a data map that I am trying to use in Excel and when I drag an element from the XML to the the header of a column in the data the following error is returned:

    the operation cannot be completed because the result would overlap an external data range or PivotTable.

    I can not locate a fix for this error - thanks in advance.

    Shihalud

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Converting Excel list to XML (Excel 2003)

    Hi Shihalud

    It may be the way the worksheet cells are formatted, have a go at copying the data you want to export to XML into a clean worksheet in the workbook and try again to export...I've seen this happen at my office occasionally
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •