Install and Configure Office Web Apps for SharePoint 2010

Introduction:
Office Web Apps is introduced for the benefit of remote users who don’t have Microsoft Office installed in their machines. This implementation guide walks through step by step on: Installing and Configuring Office Web Apps in SharePoint 2010.

Steps Overview

To install office web apps in SharePoint 2010, it takes these three steps:

  1. Install Office Web apps binaries & run products and technologies configuration wizard
  2. Start the Office web
    Apps services and create service applications
  3. Activate the Office web apps in site collections

Important

  • When installing on a SharePoint farm (not a standalone installation), you will need to install Office Web Apps on every server. You can load balance and install Office Web Apps on multiple servers to optimize performance.
  • Service accounts you use need to have read/write access to the SharePoint Configuration database and all content databases that house the site collections where Office Web Apps was activated

1. Install Office Web Apps

Download and start Office Web apps installation by running setup.exe. Provide the product key on Enter Your Product Key page, and click Continue.

install office web apps SharePoint 2010

Check the box next to I Accept the Terms of This Agreement and click “Continue”

sharepoint 2010 office web apps product key

Choose the file location and click on “Install Now” button

install office web applications sharepoint 2010

Wait for the installation to complete

install office web apps in sharepoint 2010 server

Run Products & Technologies configuration wizard

Upon successful installation, we will be presented with the “Run Configuration Wizard” window. Leave the checkbox ticked, next to Run the SharePoint Products Configuration Wizard and click “Close”.

5.Install and Configure Office Web Apps

If you didn’t tick the checkbox, and closed the wizard by mistake: Launch the Product and Technologies Configuration wizard from:

Start >> Programs  >> Microsoft SharePoint 2010 Products  >> SharePoint 2010 Products Configuration Wizard and let it run.

Click “Next” on the Welcome to SharePoint Products window

configure office web apps sharepoint 2010

Click >> Next and click Yes to acknowledge the restart of IIS, SharePoint Administration and Timer Services.

office web apps sharepoint 2010 installation 

Click Next

install office web apps in sharepoint 2010

Click Next

install office web applications in sharepoint 2010

Click Finish to complete the successful office web apps installation
how to install office web applications sharepoint 2010 

2. Start the Office web apps services & create Service Applications

The next step is: starting the required Office Web Apps services from Central Administration >> System Settings >> Manage services on the server.

12 install and configure office web apps

Start these Services:

  • Excel Calculation Services
  • PowerPoint Service
  • Word Viewing Service
sharepoint 2010 office web apps services

Creating Service Applications

Let’s create service applications for office web applications by navigating to Central Administration >> Application Management >> Manage service applications.

sharepoint 2010 office web apps service application

Click on New >> PowerPoint Service Application

sharepoint 2010 office web apps create service application

Enter the following details to complete the creation of the PowerPoint  Service Application.  Make sure you select “Add Application Proxy to Default group” check box.

sharepoint 2010 office web apps service application

Make sure the service application pool account has db_owner access rights on the content databases. Click OK

Now, We have the PowerPoint service application ready.  Repeat this step for other service applications: “Word Viewing Service” and “Excel Services Application”

16 install and configure office web apps

Activate the Office Web Apps

We must activate Office Web Apps on each site collection based on our requirements. PowerShell can be utilized to activate Office web apps on multiple site collections at once!

$webAppsFeatureId = $(Get-SPFeature -limit all | where {$_.displayname -eq "OfficeWebApps"}).Id

Get-SPSite –limit ALL | foreach  {
enable-SPFeature $webAppsFeatureId –url $_.URL }

Browse to the site collection, click on Site Actions >> Site Settings.

Under Site Collection Administration, click on Site Collection Features.

sharepoint office web apps activate

Navigate down the page until you find Office Web Apps and click on Activate.

sharepoint office web apps activate

You should now be able to open a Microsoft Word document from a document library on your SharePoint site and it should launch within the browser by default.

By default, Office Web Apps makes documents to open in browser!

Unit Test:

You should now be able to open any Microsoft Office document, Excel Sheets, PowerPoint Presentations from SharePoint document library by just clicking on View in Browser, Open in Browser ECB Menu items.

If you see View or Edit in Browser as a menu item, your Office Web Apps is configured correctly.

21 install and configure office web apps

This should render the document in the browser and enable the end user to edit.

19 install and configure office web apps
office web apps sharepoint 2010 document
In SharePoint 2013, Office Web Apps is no longer a service application that is part of your SharePoint farm. Instead, it is installed as a separate farm.

Salaudeen Rajack

Information Technology Professional with Two decades of SharePoint Experience.

Leave a Reply