power pivot for xml error RRS feed

  • Question

  • Iam facing error in sharepoint 2010 power pivot for xml files .

    The error is the data connection in this workbook contains fillowing connections : xml maps.

    Sunday, November 13, 2016 4:58 PM

All replies

  • Hi Cool,

    When you connect to external data, Excel automatically creates an external data range which is a defined name or table name that defines the location of the data. The only exception to this is a PivotTable report does not use an external data range.

    In Excel, you can format and lay out an external data range or use it in calculations, as with any other data.For external data ranges that are created from a Web query that retrieves XML data, use the XML Map Properties dialog box to change these external data range properties. Do you use  a Web query to load the data? Please share more details for further analysis. 

    Best Regards,

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, November 14, 2016 3:02 AM