SharePoint Publish Options button missing

Question

We recently purchased Office 2010 Home and Business and need to define parameters for a spreadsheet we are publishing to Excel Services in SharePoint. The problem is, the "Publish Options" button is missing from the SharePoint section in the Save & Share backstage. Here is a screenshot of what we see: http://dl.dropbox.com/u/2058/excelsharepoint.png

We are expecting to see the "Publish Options" button, pictured on this page: http://blogs.office.com/b/microsoft-excel/archive/2009/11/23/uncovering-publish-to-excel-services-in-excel-2010.aspx

Any ideas?

Thanks,

Derek

Answer 1

I had the same issue with a co-worker's computer. Apperently it is only a feature of Office 2010 Professional Plus. Once he upgraded from Standard, the button showed up.

Answer 2

Here's another screenshot from after we connected to our SharePoint server: http://dl.dropbox.com/u/2058/excelsharepoint1.png. As you can see there is no "Publish Options" button.

Thanks,

Derek

Answer 3

U'll have to click on the browse button and then choose the location on the SharePoint location where you want to publish the file... Since it does not where to publish, there is no publish button :)

 

BLACK BARRON

---

P.S : Please post back with the status of the issue. If this post was helpful to you, please vote for my post If this post has helped you resolve your issue, please mark my post as answered.

No, we're able to publish to SharePoint just fine, but we need the Publish Options button to specify which parameters to add (from the cells we defined). This is the window we're trying to access: http://blogs.msdn.com/blogfiles/excel/WindowsLiveWriter/UncoveringPublishtoExcelServicesinExcel2\_12F39/image\_5.png

(we need the parameters tab).

Answer 4

U'll have to click on the browse button and then choose the location on the SharePoint location where you want to publish the file... Since it does not where to publish, there is no publish button :)

BLACK BARRON

---

P.S : Please post back with the status of the issue. If this post was helpful to you, please vote for my post If this post has helped you resolve your issue, please mark my post as answered.