You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
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:
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.
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!
In the new version, do you have to be one of the ultra privileged Office Pro Plus or Office Enterprise users before you can gain access to the "Save to SharePoint" button?
Thanks for the post. I've been using Excel 2010 and SharePoint 2010 beta for a while now, but having some problems publishing a workbook to SharePoint. I can share the document sucessfully and view in Excel Services, but whenever I go into backstage and select Share > Save to SharePoint no known SharePoint locations appear and there isn't a link to make Excel aware of locations. I'm able to save the workbook locally and set parameters and the like, but I then need to go to the SharePoint 2010 site and manually upload the doc. Have you seen cases where the 'Known SharePoint Locations' is blank? How can I add locations to this view?
If we do not have sharepoint, how can we make use of excel services and is it freely distributed as stand alone outside MOSS? if yes where can we download it?
Excel Services is not available as a standalone outside of SharePoint Server Enterprise Edition. It is not available as a free download, nor is it part of SharePoint Server Standard Edition.
You will be able to use the Excel Web App (and the other Office Web Apps) on Windows Live/SkyDrive - this is free.
we downloaded the office 2010 excel, sharepoint.
i am not able to upload the 2010 excel pivot table to excel services. from Excel, the save dialog just does not show the http paths where the document is to be saved, neither does it launch the browser. it just saves the excel file.
can u help please ?