Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Bradley Schacht

Bradley is a consultant at Pragmatic Works in Jacksonville, FL. He was an author on the book SharePoint 2010 Business Intelligence 24-Hour Trainer and tech edited the SQL 2011 Bible. His experience on the Microsoft BI platform includes DTS, SSIS, SSRS, SSAS and migrations and conversions. He has helped numerous companies in successfully developing and implementing new business intelligence solutions into their organizations. Bradley also participates as a speaker in community events like SQL Saturday, Code Camp, SQL Lunch and SQL Server User Groups. He is a contributor on sites such as and SQL Server Central as well as an active member of the Jacksonville SQL Server User Group (JSSUG).

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:

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:


Leave a comment on the original post [, opens in a new window]

Loading comments...