How to manually install the Office Web Parts in SharePoint v3

Have you tried to install the Microsoft Office Web Parts and Components  ( STSTPKPL.exe ) on MOSS 2007 or WSS v3 only to find that when you do the install nothing happens?  I have and I didn't like what I found.  They do not install. 

This is because Microsoft has announced that the 2003 version of the Office Web Components will be the last. Read their announcement if you want to read all of the reasons why.  :)  I am too lazy to retype them.

Luckily with a little effort I have found that you can manually install them.  I actually came across this issue while working on Upgrading From SharePoint 2003 to SharePoint 2007 for SharePoint Solutions.  (Which as a side note sold out the September class already and is almost full for October.  Everyone seems very eager and excited about the upcoming SharePoint.  I am!)

Ok.  Enough gibberish how do you install them?

You will need to find the CAB files first.  If you have a v2 server with them installed that is very easy to do.  They are located in

c:\program files\common files\micrsofot shared\web server extensions\60\wppacks.

And the 3 cabs you are looking for are

  • microsoft.sharepoint.solutions.greatplains.cab
  • microsoft.sharepoint.webparts.quickquote.cab
  • microsoft.office.dataparts.cab

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

Remember that STSADM.EXE is now located at c:\program files\common files\microsoft shared\web server extensions\12\bin\stsadm.exe

You may or may not have to do an iisreset after the install.  I haven't yet but you just never know.  After all SharePoint is still in beta. 

Hope this helps!

Shane SharePoint Help

Remember that STSADM.EXE is now located at c:\program files\common files\microsoft shared\web server extensions\12\bin\stsadm.exe

You may or may not have to do an iisreset after the install.  I haven't yet but you just never know.  After all SharePoint is still in beta. 

Hope this helps!

Shane SharePoint Help

58 thoughts on “How to manually install the Office Web Parts in SharePoint v3”

  1. HELP:
    I only loaded this cab file:
    microsoft.office.dataparts.cab

    I was able to load the Webcapture web part but I get an error it says:
    to make sure that the Web Capture ActiveX Control is installed and that the browser supports Active X… which the browser does.

    What the Heck is the Web Capture Active X control that needs to be loaded?

    Do I need to load the other two Cab files also?
    microsoft.sharepoint.solutions.greatplains.cab
    microsoft.sharepoint.webparts.quickquote.cab

    Is this a Frontpage 2003 issue item? or is it something else?

    Dan

  2. help!
    I was able to isntall the cab file for the Web Capture webpart… but I didn’t install the other two: microsoft.sharepoint.solutions.greatplains.cab
    microsoft.sharepoint.webparts.quickquote.cab

    and now I’m being told that I must make sure that the browser has ActiveX support which it does. and that the WebcaptureActive X control is loaded?
    What is the Webcapture active X control?
    Is it in Frontpage? or is it something else?

  3. Thank you – immensely useful – we would have had serious problems without this and might have needed to abadon the migration to WSS2007. Shame on Microsoft for not providing the facilities to do this simply using the toolset.

  4. This will be wonderful (when I get it installed), I’m having an issue running the stsadm.exe command. It is giving me a “Object reference not set to an instance of an object.” error and then saying “The web part deployment failed.

    Any ideas?

  5. Help !!

    I was able to isntall the cab file for the Web Capture webpart.

    I get an error when I click on create button. The error is to make sure that the browser has ActiveX support which it does. and that the WebcaptureActive X control is loaded?

    can someone help he. Thanks ! IE- 7

  6. Heard that MS IT is now running these parts on their Intranet. How funny is that.

    Goes to show sometimes functionality wins out over security. Especially on an Intranet.

    Goes to show that there are trade offs you have to make with your business. These parts may not make sense on an extranet, but hey do you trust ActiveX on your Intranet?

    Ping Shane!

  7. To configure the web capture web part requires that you have the activex control for it installed on your machine. This control is part of excel 2003. I have yet to get it to work on my dev box, since I have office 2007, which does not come with that activex.

  8. I’m having an issue running the stsadm.exe command. It is giving me a “Object reference not set to an instance of an object.” error and then saying “The web part deployment failed.

  9. If you no longer have a WSS2.0 installation to refer to, the cab files can be found in the install directory created by running the Office Web Parts program (before it fails). Mine was at C:\Program Files\STSTPKPL11Setup_1033. The cabs have to be renamed, but they are the same.

  10. I had no problems installing the cab into wss3. But captures don’t work properly. I can get a capture to work at the base url level only. But as soon as I sectt a specific page element like a table. The capture fails and gives the usual capture failed message. The same captures work on the wss2 platform. Anyone else have this working.

  11. Well, this good to find what we all looking for. Question is OWC is not going to be around for long.
    Then How we are going to use Pivot table to show olap/cube data in sharepoint.

    I am still reading and don’t know much…but there is some thing “Excel Services” is alternate but it’s part of Portal Server.

    I was able to use WSS 2.0 + OWC in Windows 2003 server for free. It that means now I have to buy Portal Server just to show cubes on web page?

    Thank you – Ashok

  12. We did a gradual upgrade from V2 to V3.
    When V2 and V3 co-exists on the Front-end server, I get the following error on V2 sites.
    “There was a problem with the Web Capture request sent from the client computer to the server computer.”
    Any inputs please?!

  13. Has anyone run into an issue where a report in an OWC will just break randomally, and only works if you reset your machine?

  14. I have the same problem with the ActiveX error. Has anyone ACTUALLY used the Web Capture Web Part with MOSS 2007 / WSS v3 or is this just horseshit?

  15. I have seen the Web Capture Web Part work just fine on 2007. I have also heard some people claim they could not get it to work. :( Luckily all of my customers it has worked just fine so I have not had to troubleshoot it.

  16. I had worked with share point portal server 2003. where i was able to get all office web parts in virtual server gallary. currently i m working with share point version 2007.i have to work with office web parts for dashboard creation.but still i m not able to install this webparts in this current version.

  17. Good post… but has anyone actually used the pivots controls on WSS 3.0. The Web viewer runs fine but i am unable to load external data source for my pivot controls.

    Tried different things… eventually the controls started to crash my explorer (version 7)

    Can anyone help on pivot controls?

  18. Hi

    I followed the instructions and installed the web parts successfully.

    However if I select the Office Pivot Chart and I try to connect to an external data source IE 7 crashes.

    I receive an error messge stating that a problem has occurred with the add-on and IE 7 must close.

    This is so frustrating. Any ideas would be highly appreciated.

    Thanks so much

  19. Hi

    I followed the instructions and installed the web parts successfully.

    However if I select the Office Pivot Chart and I try to connect to an external data source IE 7 crashes.

    I receive an error messge stating that a problem has occurred with the add-on and IE 7 must close.

    This is so frustrating. Any ideas would be highly appreciated.

    Thanks so much

  20. I installed the web parts successfully a while ago when we were all on Office 2003 and IE 6, but no one is using them yet. We are moving to Office 2007 and IE 7. Any issues with Office 2007? (I see comments about crashes with IE 7 and problems with MOSS.)

    Also, Any conflicts with Excel Services? (We are considering MOSS) And, Any bad things that might happen to WSS if I uninstall the web parts (using Add/Remove Programs entry)? (WSS taking a nosedive, Sites not working, etc. Ok, I’m paranoid.)

    Thanks!

  21. Hi

    I posted a question earlier with regards to using Office 2007, SharePoint Services 3.0 and the Office Web Parts and Components.

    We have encountered a problem with connecting to an external data source.

    When attempt to do this we receive an error stating the IE has encountered a problem with the add-on and needs to close.

    We really need to resolve this problem and I would like to ask if anyone has any suggestions?

    I was considering removing Office 2007 and installing Office 2003.

    Would this be a possible solution?

    Many Thanks

  22. Hi

    I posted a question earlier with regards to using Office 2007, SharePoint Services 3.0 and the Office Web Parts and Components.

    We have encountered a problem with connecting to an external data source.

    When attempt to do this we receive an error stating the IE has encountered a problem with the add-on and needs to close.

    We really need to resolve this problem and I would like to ask if anyone has any suggestions?

    I was considering removing Office 2007 and installing Office 2003.

    Would this be a possible solution?

    Many Thanks

  23. I found this post after upgrading our Production server V2 > V3.
    And everything worked as advertised.
    However, my test server, which was built WSS V3 from scratch refused to render Web Captures with Table elements specified.
    After a bit of trial and error I have identified the V2 dll OSAFEHTM.DLL needs to be visible to IIS.
    I started with the entire 60 hive and whittled down to one file.

  24. I have SharePoint 2007 as first install (no migration). Do I still need Microsoft Office Web Parts and Components? It was on the machine, but it got uninstalled using Add/Remove programs.

    Thanks.
    Aleksandra

  25. Hi –

    We just loaded WSS 3.0 and need to get it up and running with Office 2003. We are not upgrading from v. 2. Is there any way to get the cab files we need WITHOUT doing a WSS 2.0 install? Any advice would be appreciated….

    Thanks,

    Nina

  26. Hi, I would like to know if anyone can help me with something. I’ve installed OWC on a sharepoint 2007 and locally I can obtain information from a sharepoint list, inside the domain. But when I try to reach it from the outside I can see the columns on the list but the pivot table is not created. Error 0x80004005.

    I’ll really appreciate your help on this issue. Regards.

  27. Did anyone figure out the solution to IE 7 crashing when attempting to interact with the Office PivotChart web part?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>