Which Excel, Visio and other Office products can "Publish" to SharePoint

 

A frequent question I get is "I can't publish to SharePoint". Not all editions of Excel and Visio have the publish feature!

Excel and Excel Services

Any edition of Excel can save files to a SharePoint library. Only the following editions of Excel 2010 can publish to Excel Services:

• Microsoft Office Professional Plus 2010
• Microsoft Office Professional Academic 2010
• Microsoft Excel Stand-Alone 2010

Details: http://support.microsoft.com/kb/2569945

 

Visio and Visio Services

Any edition of Visio can save files to a SharePoint library. The edition needed to use Visio with other SharePoint features varies:

• SharePoint Workflow import and export through SharePoint Designer 2010: Premium
• Visual mash-ups with Visio Services: Professional and Premium
• Publishing of diagrams to SharePoint Process repository: Standard, Professional and Premium
• Publishing Visio Web (.vdw) drawings to SharePoint: Professional and Premium
• Automatic Data Linking to data sources in SharePoint: Professional and Premium
• Real-Time sharing of dynamic, data-driven diagrams via a browser using Visio Services: Professional and Premium

Details: http://visio.microsoft.com/en-us/TryBuy/Pages/Edition_Comparison.aspx,  http://technet.microsoft.com/en-us/library/ee663485.aspx and http://office.microsoft.com/en-us/visio-help/save-diagrams-to-sharepoint-as-web-drawings-HA010357073.aspx

 

SharePoint 2010 Services and Features by edition:

http://sharepoint.microsoft.com/en-us/buy/Pages/Editions-Comparison.aspx

 

.

Excel Services and Chart Web Part Error

SharePoint 2010 Enterprise Edition

 

 

“An unexpected error has occurred.”

 

Here’s a great error message from the SharePoint 2010 Chart Web Part when attempting to connect to an Excel Services published workbook:

To add to the fun, the correlation ID does not show up in my Event log or the SharePoint logs.

 

Here’s the steps to reproduce:

1. Create an Excel file
2. Publish it to a library
3. Add a Chart Web Part to a page
4. Click Data and Appearance
5. Click Connect Chart To Data
6. Click Connect to Excel Services
7. Enter the path to the published file and the range of cells to use
   
8. Click Next
9. ERROR!

The problem?

The chart required each column to have a heading. My Excel file did not have a heading in A1:

The fix? 

Type something in cell A1… I.e. add a heading for each column:

 

Looks like a great opportunity for a better error message!

.