2

I have uploaded an xlsx file that I would like to use EWA to display using Excel Web Services. I have confirmed that the site is a trusted location and Excel Web Services is configured correctly from Central Admin. A simple spreadsheet works fine and renders in browser. However, for one particular worksheet I get an error when I try to point the EWA web part to it. It is indicating that it contains the following features that are unsupported by Excel Services. The error references sharepoint lists as the feature not supported. What is SharePoint Lists referring to? I removed the data connection that existed in the workbook but that still didn't work.

  • Did you ever find the answer to this that you can provide? – Alex Angas Jun 6 '11 at 4:19
1

If I am not mistaken you cannot use a SharePoint list as a datasource in an Excel sheet which in turn is displayed as a web drawing. Now with SP2010 there are ways to work around this:

Microsoft SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010

User-defined functions (UDFs)

Web Services API

Java Script Object Model (JSOM)

But because your tag is SP2007 I am afraid it won't work. See :
MSDN reference

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.