SharePoint Technologies, Enterprise Content Management, Search,
.NET, and Office Developer Information for the IT Professional
 Ray Ranson
>> sharepoint methods
Granite
  
Bookmark and Share

Ray Ranson's SharePoint Methods Blog > Posts > Excel Services and Office 2007 Flavors
Excel Services and Office 2007 Flavors

Some clients I have worked with have taken hold of Excel Services and are asking for clarification on requirements for publishing Excel Services Web based workbooks. Per Microsoft documentation, you need Microsoft Office Ultimate 2007, Office Professional Plus 2007, Office Enterprise 2007 and obviously, Office Excel 2007. Since you get Office Excel 2007 throughout the entire Office 2007 product line (see table below) there's some clarification needed here: In order to get the enhanced UI in Excel using the Publish menu and subsequent 'Save As' options to hide or expose workbook data, you will need one of the prior mentioned Office flavors.

Excel Services Publish options between Office versions.

Options available within Office 2007 Plus, Enterprise and Ultimate.

So, even if you have Office Home, Office Student, Standard and Small Business or Professional (Not Plus, Ultimate or Enterprise) you can still publish through 'Save As' by entering the full path to the Document Library http://server/DocumentLibrary/ Of course all MOSS farm server Excel Services settings are still required for web browsing to the published workbooks. Click here for the Channel 9 video download which outlines some of those requirements. Yes, you will lose out on a lot of Excel Services options as shown in the same video but you can still publish the 2007 versions (XLSX) of your workbooks straight into an Enterprise version of MOSS and view through clicking on the workbook in the doc lib or the Excel Web Access Web Part.

See Also: http://office.microsoft.com/en-us/products/fx100487411033.aspx

Product Suite

Excel Services Publishing Options

Office Home and Student 2007

Save As

Office Standard 2007

Save As

Office Small Business 2007

Save As

Office Professional 2007

Save As

Office Professional Plus 2007

Publish

Office Enterprise 2007

Publish

Office Ultimate 2007

Publish

Comments

There are no comments yet for this post.
Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Comment Date *

Required For Spam Purposes

Name - Optional


Body *


Attachments

 Blog Posts

Troubleshooting Virtualized SharePoint Farms – Part IUse SHIFT+ENTER to open the menu (new window).
SharePoint Services on AzureUse SHIFT+ENTER to open the menu (new window).
Virtual SharePoint DevelopmentUse SHIFT+ENTER to open the menu (new window).
Dashboard Reporting with Excel Calculation Services and KPI’s in MOSS 2007Use SHIFT+ENTER to open the menu (new window).
Excel Services and Office 2007 FlavorsUse SHIFT+ENTER to open the menu (new window).
Microsoft IT Site Delete Capture 1.0Use SHIFT+ENTER to open the menu (new window).