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
.
