Fresh Content on SharePointJoel.com SharePoint Ads
Subscribe in a reader
The Office Web Components are both a client and server technology. Hopefully answers relating to both can be had here.
Client: OWC11.exe for Office 2003 can be found here.
Server: STSPLPK.exe for WSS 2.0 can be found here. (Don't try to install this on your WSS 3.0 server)
First let me point you to the OWC roadmap. We can mostly say goodbye since the client components still ship in Project 2007, but are depricated in the Office 2007 client and in WSS 3.0 and SharePoint Server 2007.
Office Web Components “Roadmap”
There is a few paragraphs on TechNet burried in a Office 2007 changes document. I've copied the relevant paragraphs below for your reference. Both the client components (activeX controls) and server dwps and cab are referenced on that page.
With the release of IE 7, WSS 3.0, and SharePoint Server 2007 the OWC or Office Web Components like the pivot spreadsheet, pivot charts, stock quote, etc... The explanation and conversations I've had around these components was the fact that they required an activeX control. The more we can do with server side that prevents users from having to accept controls, the better in my opinion. I've been ok that these aren't in the box by default. I've had to troubleshoot these a few times more than any other of the out of the box web parts. Looking at trust and trying to manage this over SSL and for an FQDN for an external URL was a pain. Glad to see this dependency removed and replaced with server rendering and clientless (reach) experience.
Here's a snippet from the comments in the blog post above (the roadmap) from the Excel team.
"Just to be clear, OWC will still be available via web download and supported per the timeline posted by Dave Gainer. You still have the option of using OWC in your solutions. However, we will no longer be investing in new features for OWC."
If you look at it in terms of the overlap that we were giving you with Excel Services the majority of what you were doing with the activeX control/web components are now light weight.
Shane Young has a practical post on how to install them on your SharePoint Server.
Here's a snippet. First he identifies them... They are in the MSI STSPLPK.exe, but they are compressed. If you use them, you'll have to grab them off your WSS 2.0 server where they are currently installed. This spanish post actually contains one of the cabs and appears to have additional data about the use of the OWCs.
<quote>
Now that you have the files you just need to add them using
stsadm.exe -o addwppack -filename "c:\program files\common files\micrsofot shared\web server extensions\60\wppacks\microsoft.office.dataparts.cab" -globalinstall
</quote>
I recently had a dialgue with a colleage about a customer deployment. He asked if he thought he should upgrade and re-deploy the server side components and I told him that if he could... he should try to remove his dependencies on it. Someone that is starting fresh, I would strongly encourage them not to use these. In fact I'd consider it a poor practice this day and age to create web parts or portlets that have client components specifically controls (Java, JVM, or ActiveX) where they could otherwise build the components server side. AJAX and clientside Javascript is another matter.
I hope no one minds if I take the applicable paragraphs out of this reference doc...
From TechNet concerning the Office Client component OWC
Description: OWC11 is removed from the 2007 Office release and now ships only with Microsoft Office Project 2007. The DataFinder functionality in OWC11 is also removed. This affects solutions that use the spreadsheet, chart, pivot table, and data source control functionality of OWC11 in a Web page or client program that requires installation of this ActiveX control on the user's computer. The user experience varies depending upon the host container of the OWC11 ActiveX control.
For Web pages, users might see a broken icon or a notification that OWC is required. For client programs, users might receive a runtime error or other notification. In these situations, users download OWC11 from the Microsoft Download Center. The notification message generated by Office programs provides a link to the download location for OWC11. Neither Microsoft Office Excel 2007 nor SharePoint Designer 2007 now generate Web pages that use OWC.
Reason for change: New technologies such as Microsoft Windows SharePoint Services 3.0 with Excel server side capabilities and the new charting component in the 2007 Office release replace some features of OWC11.
Migration path: When the 2007 Office release is installed, previous versions of Office are removed by default. This prevents software conflicts and ensures that you have the latest versions of shared components. As a result, OWC installed with previous versions of Office is removed. If you have documents or solutions that depend on OWC, these solutions do not function properly if the correct version of OWC is not installed on the client machine. There are three primary courses of action:
1.
Install the correct version of OWC on the appropriate client computers. The installation can be performed in the following ways:
If there is wide usage of OWC throughout your corporation, OWC can be chained into the installation of the 2007 Office release using the Office Customization Tool. You can obtain the necessary version of OWC (OWC10 or OWC11) from the Microsoft Download Center at Office XP Tool: Web Components (for OWC10) or Office 2003 Add-in: Office Web Components (for OWC11).
If there is small or localized use of OWC in your corporation, you could allow users to download OWC from the Microsoft Download Center on an as-needed basis. If OWC is not found on the client computer when the Web page displays, pages authored with Excel 2003, FrontPage 2003, and Access 2003 that require OWC display a link to the OWC download location. For custom solutions that use OWC, follow this same process of checking for OWC and displaying a download link if OWC is not installed.
2.
Migrate OWC-based documents and solutions to a comparable technology, such as Excel Services. This option largely depends on the importance of the documents or solutions, the length of time they will be in service, and the degree to which OWC solves your business issues.
3.
Discontinue the use of documents or solutions if they are no longer needed.
Concerning the Server Components AKA Office Plus Pack.
Description: Ststpkpl.exe is no longer downloaded for the 2007 Office release. The following functionalities are no longer available: PivotView Web Part, Spreadsheet Web Part, QuickQuote Web Part, WebClipper Web Part, Great Plains DSP, Great Plains solutions, SQL DSP, InfoPath templates, Rich Issues List.
Reason for change: OWC, which represents the main set of Web parts in this download, is deprecated. In addition, the Great Plains solutions are superseded by offerings from Microsoft Business Solutions.
Migration path: There is no migration path for OWC. For Great Plains solutions, use the Microsoft Business Solutions Center. For the QuickQuote Web Part, use the MSNBC quote Web part.
Italics & empasis added.
<update>
Due to a couple of recent comments, I need to clarify my thoughts
I post these links because I know that these web parts are primarily heavy activeX controls. So my commentary is... if you need this functionality, follow Shane's steps of adding the OWC assemblies that you need. I recommend not deploying the ones you don't. To tell you the truth, MS IT does run some of these on their Intranet. They do not have any on any of the publishing platforms or on the extranet deployments. That's basically how I would direct people as well. If you need the functionality on your intranet and don't have a problem with ActiveX, then go for it. The weather web part for example could be consumed from an RSS feed, Dustin Miller [MVP] of SharePoint Experts did an example of this at SharePoint Connections.
Wasn't my decision, but from a security standpoint and the usability in IE 7 in internet zone... it makes sense.
</update>
A few errors make this a bit of a joke (and a frustration to many in the field).
"Reason for change: New technologies such as Microsoft Windows SharePoint Services 3.0 with Excel server side capabilities "
What Excel Server capabilities are there in WSS 3.0?
One of the main uses for the OWC's in a web part was that they could chart SharePoint list/library data. Excel Services can't do this OOTB.
Maybe the future for rich UI in SharePoint is a Web Part that uses WPFE (already playing with it http://www.wssdemo.com/Pages/wpfe.aspx)
Hi Joel,
Moving away from ActiveX controls to server-side rendering is great. However, the Excel Services rendering functionality it only available in MOSS 2007 with Enterpise CALs.
I think the OWC web parts will still be used for some time to come by WSS v3 and MOSS 2007 Standard users.
Ivan
It was a real bummer when I found out :( <echem...> note that after you install Office 2007, you have to reinstall the client web part components or you wont see them on a 2003 portal/site you are accessing.
Joel:
This post borders on the laughable, often the case when people start talking without a fundamental understanding of the technology. OWC is deprecated in favor of what? Excel Services. Please. There is no hook in Excel Services to draw a chart, pivot table or spreadsheet - the things knowledge workers use. What do you suggest real world programmers do? GDI Pens and brushes to put a bunch of rectangles together and call it a chart? The EWA web part that is exposed does not allow the developer to manipulate the spreadsheet itself. Excel services changes the orientation of the spreadsheet to a side control input. Why? Google spreadsheets allows users to enter data in cells, what is so special about MS spreadsheet? Did MS stop to consider the training issue to get users comfortable with this new orientation? Not to mention the fact that you can only publish a spreadsheet using Professional plus version or full office 2007. Notice that the CAL licensing issue is way in the background taking a back-seat to the marketing hype. Any large enterprise will tell you they are a few years away from switching. Factor in the cost and i bet you most folk will stay on office xp, or 2003. Ribbons aint worth the hassle, trust me. In case you bothered to follow the Office adoption rate in the real world, Office 2007 for most enterprises is not happening any time soon. It's ok to shove that stuff down someone's throat if they don't realize what's going on, but intelligent, knowledgable people also read these blogs as well. Here's to the deprecation.
Currently, we are using DAP's developed in OFFICE 2003, & PAGE VIEWER web parts on SHAREPOINT...
Most of our users are still running OFFICE 2003; what about when they migrate to OFFICE 2007? Is the solution simply to have them download/install OWC 11 on their machines? Will this functionality go away? What (other) solutions (if any) are there to NOT losing this functionality? We spent a LOT of time developing these solutions & don't really want to see it go to waste....????
Oh, also, Joel... will WSS 2007 retain the PAGE VIEWER WEB PART? I couldn't see an answer to that question here (or maybe it never got asked in the first place).
Thanks!
Oh, also, Joelo... will WSS 2007 retain the PAGE VIEWER WEB PART? I couldn't see an answer to that question here (or maybe it never got asked in the first place).
Pivottabeller m.fl. i Dynamics Ax 4.0 behöver web komponenter som ingick i Office 2003. Om du installerar
I hear this question at least at every conference, and I'm sure there is no right answer. Of course I