Excel Services, Save As does not show Publish Options

Question

I have created a document library and configure it to have a Document Template Excel Spreadsheet. When I create a new Document and then save the new Excel worksheet, by selecting File -> Save&Send -> Save to SharePoint and select the document library the Publish Options button is not shown.

I gues that this is a configuration issue. I have checked the configuration for Excel Services Application but I cant find any obvious cause.

Anyone?

Answer 1

If you made the Excel template the default content type for the document library and you click on the "new" button to create a document from there, simply clicking the save icon will save your document back to that document library. Since the document library was the "source" of the new spreadsheet, you do not need to configure it as the publishing target.