External Data Ranges error Publishing Excel Sheet in Sharepoint and browsing

Question

Hi All,

I have Done a Pivot-table with External Data Connection as Analysis Serivce CUBE and Published in Sharepoint Document Library.

Iam able to browse the Excel sheet but geting a error saying : " External Data Ranges(also called Query tables) the following feature is not supported)

How to resolve this?

Is this Unsupported Feature in Excel Services.

Thank you

Answer 1

 

Hi krishna_ece,

If you want to work with table data based on an external data connection in Excel Services, you can't use an external data range (also called a query table). You must create a PivotTable report that flattens multidimensional, hierarchical data into a table, or two dimensions. Here is an official article about use a PivotTable report to make external table data available in Excel Services:
http://office.microsoft.com/en-us/excel-help/use-a-pivottable-report-to-make-external-table-data-available-in-excel-services-HA010207979.aspx

Thanks,
Lhan