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.

Improve this question
1
  • Did you ever find the answer to this that you can provide?
    – Alex Angas
    Jun 6, 2011 at 4:19

1 Answer 1

Reset to default
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

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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