Unsupported Features in Excel Services SharePoint 2010

Between SharePoint 2007 and SharePoint 2010 there were many new features that were added or enhanced.  There still remains a list of items that are either unsupported actions, such as workbook authoring, or unsupported features, such as cell comments.

In Excel Services 2007 many unsupported features would cause the workbook to not load at all and have since had the behavior changed in 2010.  The following is a list of features that would prevent the workbook from loading in 2007.  They are still unsupported in 2010, but will render as static objects and still let you interact with the rest of the Excel workbook:

  • Cell comments.
  • Formula references to external books.
  • Query tables (also known as external data ranges).
  • Microsoft Visual Basic for Applications (VBA).
  • Any OfficeArt technology. For example, Shapes, WordArt, SmartArt, organization chart, diagrams, signature lines, ink annotations, and so on.

One common error is “The current selection is not within a refreshable region of the workbook.” The main location you will run into this is when trying to refresh a table.  As noted above query tables are still not supported, but will render static in the workbook.  If you want data refresh on those values they need to be in a Pivot Table.

A full list of unsupported features can be found on MSDN.

Supported and Unsupported Features in Excel Services SharePoint 2010: http://msdn.microsoft.com/en-us/library/ff595319.aspx

All unsupported features from SharePoint 2007 are still valid and behave the same way unless mentioned in the link above for Supported and Unsupported Features in SharePoint 2010. A link for the Unsupported Features in Excel Services SharePoint 2007 can be found here: http://msdn.microsoft.com/en-us/library/ms496823.aspx

Bradley Schacht

Bradley Schacht is a Cloud Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Administration". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as SQLServerCentral.com and an active member of the Jacksonville SQL Server User Group (JSSUG).

You may also like...

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.