How to Configure Office Web Apps to Work with SharePoint 2013

Office Web Apps is the online companion to Office Word, Excel, PowerPoint, and OneNote applications, and enables usersregardless of their locationto view and edit documents. Office Web Apps give users a browser-based viewing and editing experience providing a representation of an Office document in the browser. When a user selects an Office document that is stored in a SharePoint document library, the document opens directly in the browser. When an Office Web App user selects the Edit in Word, Edit in Excel, Edit in PowerPoint, or the Edit in OneNote button on the toolbar, the document opens immediately in the associated Office client application (if it has been installed on the client computer).

Configuring Office Web Apps for SharePoint 2013 is a fairly simple process. The following post shows how to set up the Office Web Apps Server and configure SharePoint 2013 to use the Office Web Apps Server.

  • Windows Server 2012, for our exaample: VNGWIN2012
  • Server SharePoint 2013, for our example: VNGO15SQL2

On VNGWIN2012, running the Office Web Apps Server:

    1. Open a Windows PowerShell prompt as an administrator:
      Run the following command:
      Add-WindowsFeature Web-Server,Web-Mgmt-Tools,Web-Mgmt-Console,Web-WebServer,Web-Common-Http,Web-Default-Doc,Web-Static-Content,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Security,Web-Filtering,Web-Windows-Auth,Web-App-Dev,Web-Net-Ext45,Web-Asp-Net45,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Includes,InkandHandwritingServices

 

  1. Install Office Web Apps Server software from http://www.microsoft.com/en-us/download/details.aspx?id=35489.
      • From the root folder of the Office Web Apps files, run Setup.exe:

     

      • On the Choose a file location page, click Install Now and Close when it’s completed:

     

      • Open a Windows PowerShell prompt as an administrator and run:
        New-OfficeWebAppsFarm –InternalURL “http://vngwin2012” –AllowHttp -EditingEnabled

     

    • Verify that the Office Web Apps Server farm was created successfully by opening a browser window and going to http://vngwin2012/hosting/discovery

On VNGO15SQL2, the server that runs SharePoint 2013:

    1. Open the SharePoint 2013 Management Shell prompt as an administrator:

 

  1. Create the binding between Office Web Apps Server and SharePoint 2013. This sets up communication between the server that runs SharePoint 2013 (VNGO15SQL2) and the server that runs Office Web Apps Server (VNGWIN2012).
      • Run command:
        New-SPWOPIBinding -ServerName vngwin2012 –AllowHTTPAfter you run this command, you should see a list of bindings displayed at the Windows PowerShell command prompt:

     

      • View the WOPI zones for the SharePoint bindings:
        Get-SPWOPIZone

     

      • Change the WOPI zone to internal-http:
        Set-SPWOPIZone –zone “internal-http”

     

      • Verify that the new zone is internal-http:
        Get-SPWOPIZone

     

      • Change the AllowOAuthOverHttp setting in SharePoint 2013 to True:
        (Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp
        If this command returns False, run the following commands to set this to True.
        $config = (Get-SPSecurityTokenServiceConfig)
        $config.AllowOAuthOverHttp = $true
        $config.Update()

        Run the following command again to verify that the AllowOAuthOverHttp setting is now set to True:
        (Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp

     

  2. Verify that Office Web Apps is working on opening an Office document in a SharePoint 2013 document library.
      • Go to site http://vngo15sql2, and upload the file “Nokia shares fall.docx” to the document library:

     

      • Click on “Nokia shares fall” to open the file; it can be viewed using any supported Web browser:

     

    • And can now be edited in Word or via the Edit in Word Web App option:

SharePoint Online

The cloud parts are functional components that extend your SharePoint Online environment in Microsoft 365.

Supports Classic and Modern sites for SharePoint Online/Microsoft 365

Small Business Pricing and Discounts

SharePoint

Top SharePoint Online Products

Experience greater power and savings by bundling our SharePoint apps and cloud parts.


Calendar Plus


Chart Plus


Knowledge Base


Project Management Central


Simple List Search

 

On-Premises Only

These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.

SharePoint 2016, 2019, 2022 - Classic Pages Only

SharePoint

Top On-Premises Only Products

Experience greater power and savings by bundling our SharePoint apps and web parts.


Calendar Plus


Data Viewer


Password Change


Password Expiration


Password Reset

 

Our team of Microsoft 365 experts help you get the most out of your Microsoft technology, we have the best Microsoft 365 talent to streamline your organization.

Streamline Your Department

M365 Plus

Managed Services

We Have What You Need

Federal Contractors