Office 2016 Online

Posted onby

New features in Outlook include Online Archive support, category list sync, weather in calendar, apps for Office, and side-by-side calendar. Read more Software similar to Microsoft Office 2016 4. Sign in to Office or Microsoft 365 from a desktop application or your web browser. 2019 for Mac Word 2019 for Mac Word 2016 Outlook 2016 PowerPoint 2016 Publisher.

-->

Summary: Explains how to deploy Office Online Server on-premises for use by SharePoint Server, Skype for Business Server, and Exchange Server.

Audience: IT Professionals

Office Online Server is the next version of Office Web Apps Server. Deploying Office Online Server involves installing some prerequisite software and running a few Microsoft PowerShell commands, but overall the process is designed to be pretty straightforward. This article walks you through the procedures to get your servers ready, then gives you the Microsoft PowerShell commands to configure the on-premises Office Online Server farm.

Prepare servers to run Office Online Server

Perform these procedures on all servers that will run Office Online Server. This server must be Windows Server 2012 R2 or Windows Server 2016.

Important

Windows Server 2016 requires Office Online Server April 2017 or later. Windows Server 2019 is not supported at this time.

Office Online Server was designed and tested for server operating systems configured with default settings. If you need to deploy with non-default settings, it is recommended to begin installation and setup with the default settings. Once the system is verified as working, then incrementally add and test Group Policies, security settings and other modifications.

Step 1: Install prerequisite software for Office Online Server

To install Office Online Server

  1. Open the Microsoft PowerShell prompt as an administrator and run this command to install the required roles and services.

    Windows Server 2012 R2:

Windows Server 2016:

If prompted, restart the server.

  1. Install the following software:

Step 2: Install Office Online Server

Next, we'll install Office Online Server.

If you plan to use any Excel Online features that utilize external data access (such as Data Models, Power Pivot, or Power View), note that Office Online Server must reside in the same Active Directory forest as its users as well as any external data sources that you plan to access using Windows-based authentication.

Complete these steps on any servers that will run Office Online Server.

To install Office Online Server

  1. Download Office Online Server from the Volume Licensing Service Center (VLSC). Office Online Server is a component of Office, so it is available under each of the product pages including Office Standard 2016, Office Professional Plus 2016, and Office 2015 for Mac Standard.

  2. Run Setup.exe.

  3. On the Read the Microsoft Software License Terms page, select I accept the terms of this agreement and click Continue.

  4. On the Choose a file location page, select the folder where you want the Office Online Server files to be installed (for example, C:Program FilesMicrosoft Office Web Apps) and select Install Now. If the folder you specified doesn't exist, Setup creates it for you.

    We recommend that you install Office Online Server on the system drive.

  5. When Setup finishes installing Office Online Server, choose Close.

  6. If you're planning to use Kerberos Constrained Delegation with Excel Online, then, in Services, set the Claims to Windows Token Serviceto start automatically on this server.

If you plan to use Kerberos Constrained Delegation with Excel Online, be sure to add each server in the Office Online Server farm to the Active Directory Domain Services delegation list.

Step 3: Install language packs for Office Online Server

Office Online Server Language Packs let users view web-based Office files in multiple languages, whether they're opened from SharePoint document libraries or Outlook on the web.

To install the language packs, follow these steps.

  1. Download the Office Online Server Language Packs from the Microsoft Download Center.

  2. Run wacserverlanguagepack.exe.

  3. In the Office Online Server Language Pack Wizard, on the Read the Microsoft Software License Terms page, select I accept the terms of this agreement and select Continue.

  4. When Setup finishes installing Office Online Server, choose Close.

To patch language packs, deploy Office Online Updates after installing the Office Online Language Packs.

Important

To install language packs after the Office Online Server farm is created, you must remove a server from the farm, install the language pack on it, and then add the server back to the farm.> For a language pack to work correctly, you'll need to install it on all servers in the farm.

Deploy the Office Online Server farm

Follow the procedures in one of the following three sections, based on what kind of Office Online Server farm you want to create.

Tip

If Microsoft PowerShell doesn't recognize the New-OfficeWebAppsFarm cmdlet when you run it, you may need to import the OfficeWebApps module. Use this command:Import-Module -Name OfficeWebApps

Deploy a single-server Office Online Server farm that uses HTTP

If you're only deploying Office Online Server for testing or internal use, and you don't need to provide Office Online Server functionality to Skype for Business Server 2015, this procedure is for you. Here, you'll install a single-server Office Online Server farm that uses HTTP. You won't need a certificate or load balancer, but you will need a dedicated physical server or virtual machine instance that isn't running any other server application.

You can use this Office Online Server farm to provide Office Online functionality to SharePoint Server 2016 and Exchange Server 2016.

Note

It is strongly recommended to use HTTPS (TLS) regardless of environment as Office Online Server uses OAuth tokens to communicate with external services, such as SharePoint or Exchange Server. OAuth tokens contain information that can potentially be intercepted and replayed by an attacker, granting the attacker the same rights as the user making the request to Office Online Server.

Step 1: Create the Office Online Server farm

Use the New-OfficeWebAppsFarm command to create a new Office Online Server farm that consists of a single server, as shown in the following example.

Parameters

  • -InternalURL is the name of the server that runs Office Online Server, such as http://servername.

  • -AllowHttp configures the farm to use HTTP.

  • -EditingEnabled enables editing in Office Online when used with SharePoint Server. This parameter isn't used by Skype for Business Server 2015 or Exchange Server because those hosts don't support editing.

Step 2: Verify that the Office Online Server farm was created successfully

After the farm is created, details about the farm are displayed in the Microsoft PowerShell prompt. To verify that Office Online Server is installed and configured correctly, use a web browser to access the Office Online Server discovery URL, as shown in the following example. The discovery URL is the InternalUrl parameter you specified when you configured your Office Online Server farm, followed by /hosting/discovery, for example:

If Office Online Server is working as expected, you should see a Web Application Open Platform Interface Protocol (WOPI)-discovery XML file in your web browser. The first few lines of that file should resemble the following example.

Step 3: Configure Secure Store access (optional)

If you're planning to use the Secure Store service in SharePoint Server in an HTTP environment, there's a parameter that you need to set to enable this. (If you're not planning to use Secure Store in SharePoint Server with Excel Online, you can skip this step.)

When Office Online Server attempts to refresh data in a workbook or ODC file that is stored in an HTTP path, that data refresh will fail if you have not configured Office Online Server to allow Secure Store connections over HTTP.

Use the Set-OfficeWebAppsFarm cmdlet to configure the Secure Store over HTTP settings:

Keep in mind that the contents of the workbook or ODC file will be transmitted in clear text over HTTP. Data connected workbooks and ODC files contain database connection information, and can contain passwords.

Step 4: Configure the host

Office 2016 Online

The farm is now ready to provide Office Online functionality to hosts over HTTP. Visit the following articles for more information about how to configure hosts.

Deploy a single-server Office Online Server farm that uses HTTPS

For most production environments, we strongly recommend the use of HTTPS for its security features. Also, HTTPS is required if you want to provide Office Online Server functionality to Skype for Business Server 2015, which lets users view PowerPoint broadcasts in a browser. Here's how to install a single-server Office Online Server farm that uses HTTPS. You'll need to install a certificate on the server.

This Office Online Server farm will provide Office Online functionality to SharePoint Server, Skype for Business Server 2015, and Exchange Server 2016.

Step 1: Create the Office Online Server farm

Use the New-OfficeWebAppsFarm command to create a new Office Online Server farm that consists of a single server, as shown in the following example.

Parameters

  • -InternalURL is the fully qualified domain name (FQDN) of the server that runs Office Online Server, such as http://servername.contoso.com.

  • -ExternalURL is the FQDN that can be accessed on the Internet.

  • -CertificateName is the friendly name of the certificate.

  • -EditingEnabled is optional and enables editing in Office Online when used with SharePoint Server. This parameter isn't used by Skype for Business Server 2015 or Exchange Server because those hosts don't support editing.

Step 2: Verify that the Office Online Server farm was created successfully

After the farm is created, details about the farm are displayed in the Microsoft PowerShell prompt. To verify that Office Online Server is installed and configured correctly, use a web browser to access the Office Online Server discovery URL, as shown in the following example. The discovery URL is the InternalUrl parameter you specified when you configured your Office Online Server farm, followed by /hosting/discovery, for example:

If Office Online Server works as expected, you should see a Web Application Open Platform Interface Protocol (WOPI)-discovery XML file in your web browser. The first few lines of that file should resemble the following example:

Note

Depending on the security settings of your web browser, you might see a message that prompts you to select Show all content before the contents of the discovery XML file are displayed.

Office 2016 Online Installer

Step 3: Configure the host

The farm is now ready to provide Office Online functionality to hosts over HTTPS. Visit the following articles for more information about how to configure hosts.

Deploy a multi-server, load-balanced Office Online Server farm that uses HTTPS

If you anticipate lots of traffic to your Office Online Server farm, and you want it to be available over the Internet as well as on your internal network, this type of topology is the way to go. This section shows how to install a multi-server Office Online Server farm that uses a load balancer and HTTPS.

Before you begin, make sure your load balancer is configured. Also, you'll need to install a certificate on the load balancer. This Office Online Server farm will provide Office Online functionality to SharePoint Server, Skype for Business Server 2015, and Exchange Server 2016.

Step 1: Create the Office Online Server farm on the first server

Use the New-OfficeWebAppsFarm command to create a new Office Online Server farm on the first server, as shown in the following example.

Parameters

  • -InternalURL is the fully qualified domain name (FQDN) of the server that runs Office Online Server, such as http://servername.contoso.com.

  • -ExternalURL is the FQDN name that can be accessed on the Internet.

  • -SSLOffloaded enables offloading SSL termination to the load balancer.

  • -EditingEnabled is optional and enables editing in Office Online when used with SharePoint Server. This parameter isn't used by Skype for Business Server 2015 or Exchange Server because those hosts don't support editing.

Step 2: Add more servers to the farm

After the first server is running Office Online Server, run the New-OfficeWebAppsMachine command on each server you want to add to the Office Online Server farm. For the -MachineToJoin parameter, use the computer name of a server that's already in the Office Online Server farm. For example, if server1.contoso.com is already in the farm, use the following:

Step 3: Verify that the Office Online Server farm was created successfully

After the farm is created, details about the farm are displayed in the Microsoft PowerShell prompt. To verify that Office Online Server is installed and configured correctly, use a web browser to access the Office Online Server discovery URL, as shown in the following example. The discovery URL is the InternalUrl parameter you specified when you configured your Office Online Server farm, followed by /hosting/discovery. For example:

If Office Online Server works as expected, you should see a Web Application Open Platform Interface Protocol (WOPI)-discovery XML file in your web browser. The first few lines of that file should resemble the following example:

Note

Depending on the security settings of your web browser, you might see a message that prompts you to select Show all content before the contents of the discovery XML file are displayed.

Step 4: Configure the host

The farm is now ready to provide Office Online functionality to hosts over HTTPS. Visit the following articles for more information about how to configure hosts.

If you see '500 Web Service Exceptions' or '500.21 - Internal Server Error' messages

If features of the .NET Framework 4.6 were installed and then removed, you might see '500 Web Service Exceptions' or '500.21 - Internal Server Error' messages when you run OfficeWebApps cmdlets. To fix this, run the following sample commands from an elevated command prompt to clean up settings that could prevent Office Online Server from functioning correctly:

For Windows Server 2012 R2 or Windows Server 2016

See also

-->

Summary: Learn about Office Online Server and how it provides browser-based Office functionality to supported hosts.

Audience: IT Professionals

Office Online Server delivers browser-based versions of Word, PowerPoint, Excel, and OneNote. A single Office Online Server farm can support users who access Office files through SharePoint Server, Exchange Server, shared folders, and web sites.

Office 2016 Online Install Multi V2.8

Important

Are you looking for help with Office Online on your desktop or mobile device? You can find this information by searching for 'Office Online' on Office Support.

About Office Online Server

Office Online Server is an Office server product that provides browser-based file viewing and editing services for Office files. Office Online Server works with products and services that support WOPI, the Web app Open Platform Interface protocol. These products, known as hosts, include SharePoint Server, and Exchange Server. An Office Online Server farm can provide Office services to multiple on-premises hosts, and you can scale out the farm from one server to multiple servers as your organization's needs grow. Office Online Server requires dedicated servers that run no other server applications, however, you can install Office Online Server on virtual machines if needed.

With Office Online Server, users can also view Office files that are stored outside SharePoint Server, such as those in shared folders or other web sites. This functionality is provided by a feature known as Online Viewers.

How SharePoint Server uses Office Online Server for viewing and editing Office documents

When used with SharePoint Server 2016, Office Online Server provides Word Online, Excel Online, PowerPoint Online, and OneNote Online. Users can view and, in some cases, edit Office documents in SharePoint libraries by using a supported web browser on computers and on many mobile devices, such as Windows Phones, iPhones, iPads, and Windows tablets.

Note that Office Online Server only works with SharePoint web applications that use claims-based authentication.

The following illustration summarizes the viewing and editing capabilities of Office Online on different kinds of devices.

Viewing and editing capabilities of Office Web Apps

Excel Online includes external data connectivity and data refresh features similar to those found in Excel Services in SharePoint Server 2013. (Excel Services has been removed from SharePoint in SharePoint Server 2016 - you use Excel Online instead.)

How Exchange Server and Outlook Web App use Office Online Server for previewing Office file attachments

When Exchange Server is configured to use Office Online Server, users of Outlook Web App can preview Office file attachments by using Word Online, Excel Online, and PowerPoint Online. These previews provide rich, full-fidelity viewing of Office files and any comments within them, without downloading the files before viewing them.

By default, the following file types are displayed using Office Online Server:

  • Word documents (doc, docx, dotx, dot, dotm extensions)

  • Excel documents (xls, xlsx, xlsm, xlm, xlsb extensions)

  • PowerPoint documents (ppt, pptx, pps, ppsx, potx, pot, pptm, potm, ppsm extensions)

Note

Office Online Server won't be used to render any attachments in IRM protected messages.

Office Online integration for attachment previews is available to all Exchange Online customers. Exchange on-premises customers have to deploy Office Online Server to enable the functionality.

For more information about how to configure Exchange Server to use Office Online Server, see Office Online Server Integration.

How Office Online Server enables users to view Office files in shared folders and websites by using Online Viewers

Online Viewers enable users to use a web browser to view Excel, PowerPoint and Word files that are stored on web servers or shared folders in an organization. Users can conveniently view Office files in a web browser without having to open a separate application. In addition, Online Viewers do not require Office to be installed on users' computers. Online Viewers also generate the code that is required to link or embed the URL inside a webpage. You can use Online Viewers within your Intranet, or on the Internet.

Office Online Server provides a page at the address http:// OfficeWebAppsServername/op/generate.aspx that you can use to generate links to publicly available documents that have UNC or URL addresses. When a user selects a generated URL, Online Viewers enable Office Online Server to get the file from its location and then render it by using Office Online. The user can view the Word, Excel, or PowerPoint file in a browser with Office features intact. Formatting and layout in Word documents are preserved, data in Excel workbooks can be filtered and sorted, and animations play in PowerPoint presentations. However, be aware that Online Viewers allow users to view but not edit files, and Online Viewers can't open any files that require authentication.

You can find more about Online Viewers in Planning for Online Viewers with Office Online Server.

Note

Microsoft hosts an Internet-only facing version of Create URL on Office.com.

See also