Enabling Excel Services

Many of the features in Excel Services for rendering documents have been included in Office Online Server. To enable the integration of Excel Services integration with Office Online Server, follow these steps:

1. Following the guidance in Chapter 12, Implementing Hybrid Teamwork Artifacts, ensure that Office Online Server has been installed and configured on a separate server.
2. On a SharePoint Server in the farm, launch an elevated SharePoint Management Shell instance.

3. Run the following command, replacing <oos-server> with your Office Online server:

$Farm = Get-SPFarm
$Farm.Properties.Add("WopiLegacySoapSupport","http://<oos-server>/x/_vti_bin/ExcelServiceInternal.asmx")
$Farm.Update()

Adjust any other parameters as necessary using the Set-OfficeWebAppsFarm cmdlet on the Office Online Server computer. Commonly updated parameters include setting the ExcelWarnOnDataRefresh value to $false (to prevent repeated prompts when updating workbooks...