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

About the author

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

Add comment

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

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

Follow Me