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 Comments so far

  1.   Pieter Jan Hermans on September 21st, 2006          Reply

    exactly what I was looking for! Thanks

  2.   Mark Kruger, WSS MVP on November 15th, 2006          Reply

    Thanks! I missed the original posting and this was something I was looking for in Migration 😉

  3.   Dan on December 26th, 2006          Reply

    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

  4.   Dan on December 26th, 2006          Reply

    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?

  5.   Eugene on January 4th, 2007          Reply

    What about the Web Capture Web Part? Does that work on MOSS 2007?

  6.   dattard on February 1st, 2007          Reply

    Excellent stuff, used the above post to install the Web Capture web part. Everyone loves that part so much, both users and developers 🙂

  7.   Andrew on March 7th, 2007          Reply

    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.

  8.   Degen on March 15th, 2007          Reply

    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?

  9.   Shareuser on March 20th, 2007          Reply

    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

  10.   joelo on March 21st, 2007          Reply

    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!

  11.   Ishai Sagi on May 7th, 2007          Reply

    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.

  12.   Golf on May 13th, 2007          Reply

    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.

  13.   David on June 13th, 2007          Reply

    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.

  14.   Marc on June 16th, 2007          Reply

    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.

  15.   Ashok on June 25th, 2007          Reply

    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

  16.   Krishnan on June 25th, 2007          Reply

    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?!

  17.   Philippos on August 1st, 2007          Reply

    Interesting…

  18.   Makarios on August 1st, 2007          Reply

    Interesting…

  19.   Pat on September 10th, 2007          Reply

    Any solutions to the “Object reference not set to an instance of an object.” error. I am also having this issues?

  20.   Tyler Bithell on September 13th, 2007          Reply

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

  21.   Kam on September 27th, 2007          Reply

    That’s what I was looking for.
    Excellent.
    It’s Working perfectly with wss 3.0

    Thanks a lot

  22.   Randy Williams on October 4th, 2007          Reply

    If I don’t have an install of 2.0 where can I get the cab files?

  23.   Thomas on October 18th, 2007          Reply

    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?

  24.   Shane on October 18th, 2007          Reply

    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.

  25.   Etienne on November 7th, 2007          Reply

    You’re a star my friend, just done it and it’s great 🙂

  26.   Balasubramanian on December 4th, 2007          Reply

    Thanx a million buddy, it wonderfully worked for me. Thank You.

  27.   Tom on December 14th, 2007          Reply

    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.

  28.   Ian Morrish on January 11th, 2008          Reply

    The MS Official method for installing these can be found here…

    support.microsoft.com/…/929320

  29.   Shane on January 11th, 2008          Reply

    Wonder where they got that idea from. 😉 LOL

  30.   Umair on January 23rd, 2008          Reply

    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?

  31.   Sipho on January 28th, 2008          Reply

    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

  32.   Sipho on January 28th, 2008          Reply

    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

  33.   jremmc on January 29th, 2008          Reply

    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!

  34.   Sipho on January 30th, 2008          Reply

    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

  35.   Sipho on January 30th, 2008          Reply

    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

  36.   David McKenzie on April 2nd, 2008          Reply

    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.

  37.   Aleksandra on May 29th, 2008          Reply

    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

  38.   Nina on August 25th, 2008          Reply

    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

  39.   Nina on August 27th, 2008          Reply

    Hi,

    Nevermind my previous post. Found cab files in directions at website above.

    Thanks anyway,

    Nina

  40.   Brucelee on November 11th, 2009          Reply

    This unfortunately does not work on a 2008 Windows server with SQL 2008. Anyone get it to work?

  41.   Mario on November 19th, 2009          Reply

    Do I have to have Office 2003 on the server, or can I run the OWC’s with Office 2007 installed?? thanks!!

  42.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  43.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  44.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  45.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  46.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  47.   Install Software on February 5th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  48.   Install Software on February 6th, 2010          Reply

    Another great post.
    Thanks for the tips and help.
    Everyone, bookmark this site.

  49.   Buy Ambien on February 12th, 2010          Reply

    whatever blended abbott vacuum inaction foch fulfils learningwe sorts rubiotechwww nawlakha
    ambisoltersos makalavertonicos

  50.   Buy Ambien on February 17th, 2010          Reply

    unveil protocol sheettopic flood boots pirmuhani luck finances maidan makiz beattie
    saramartisakis kulturenostro

  51.   Fabian on March 11th, 2010          Reply

    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.

  52.   rfarqleet on April 15th, 2010          Reply

    Hi,

    Thanks this is helpful. Very Helpful Post.

    Keep it up!

  53.   Premrat on July 9th, 2010          Reply

    Hi,
    Would like to know, is there any problem if we install it on WIN2008 x64 + MOSS 2007?

  54.   Charlotte on November 4th, 2010          Reply

    I wonder if this will still work for Sharepoint 2010 ?

  55.   www.itunes.com on January 5th, 2011          Reply

    Excellent post. I want to thank you for this informative read, I really appreciate sharing this great post. Keep up your work. .

  56.   Jase on May 13th, 2011          Reply

    I’m out of laeuge here. Too much brain power on display!

  57.   sam on November 29th, 2011          Reply
  58.   Larry W. Virden on January 27th, 2012          Reply

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

Leave a Reply