Thanks to Amy Lin for putting together this post.
In Excel 2007, we introduced the ability to publish workbooks to SharePoint. This feature enabled users to upload Excel workbooks (or specific workbook items) on to their SharePoint sites for people to view and interact with using Excel Services.
In Excel 2010, this feature has all the same functionality but the entry point has changed. For the Technical Preview/Beta users, the entry point will look different since these changes will be reflected in the final release of Excel. I will walk through the workflow of how to publish workbook items to the server with the new user experience. If you want a refresher of how to publish workbooks in Excel 2007, see our previous blog entry on: How do I publish workbooks to the server?.
In Office 2010, the Office menu has been replaced by Backstage. To learn more about the Backstage View, read these blog entries:
- Microsoft Office Backstage (Part 1 â€“ Backstory)
- Save Some Time â€“ Save Some Trees
- Microsoft Office Backstage (Part 3 â€“ The Info tab)
- Evolving the Backstage View
In Backstage, the publish entry point is accessed from clicking the â€œSave & Sendâ€ tab on the left and then clicking the â€œSave to SharePointâ€ billboard in the middle.
Excel 2010 publish entry points
In â€œSave to SharePointâ€, you will find the â€œPublish Optionsâ€ button, a list of locations and the â€œSave Asâ€ button. The â€œPublish Optionsâ€ button allows you to pick specific items you want to publish. The list of locations helps you save to common locations or you can click the â€œSave Asâ€ at the bottom of the list.
Publish Entry Points
The â€œPublish Optionsâ€ button from Backstage and in the “Save Asâ€ dialog launches the dialog below:
Excel 2010 Publish Options dialog
For all the Excel 2007 users, this dialog will seem very familiar because it is the same dialog used to specify which workbook items to publish to the server. For example, if you want to publish a specific chart and a PivotTable, select â€œItems in the Workbookâ€ from the drop down and check the Chart and PivotTable you desire. In the image below, weâ€™ve selected â€œChart 3â€ and â€œPivotTable1â€.
Once you are done making your selections, click â€œOKâ€. If you clicked on â€œPublish Optionsâ€ from Backstage, you will return back to that view. Once in Backstage, if you see a recent location you want to save to, double-click on it in the list or click â€œSave Asâ€ at the bottom of the locations.
The â€œSave Asâ€ button launches the following dialog where the default location is the location selected in the gallery. However, you can change the location of the file once you are in this dialog. The â€œPublish Optionsâ€ button is exposed here so you can also select which workbook items to publish from this entry point.
Excel 2007 Save to SharePoint Save As Dialog
After clicking â€œSaveâ€, your chart & Pivot Table can now be viewed in a browser!
Excel in the browser
The publish feature behaves the same as it did in 2007. The new Backstage in Office 2010 gave us an opportunity to move the entry point to a more natural location. I look forward to any feedback you have on the publishing experience. Happy publishing!