Book Image

Microsoft SharePoint Server 2019 and SharePoint Hybrid Administration

By : Aaron Guilmette
Book Image

Microsoft SharePoint Server 2019 and SharePoint Hybrid Administration

By: Aaron Guilmette

Overview of this book

SharePoint Server is an on-premises collaboration and business productivity platform. It serves as a content management and web services platform, enabling users to create, publish, and discover content and applications and integrate with business systems. This SharePoint book offers complete, up-to-date coverage of the SharePoint Server 2019 interface to help you configure and deploy confidently from the start. With the help of clear and succinct explanations and expert tips, this book covers SharePoint Server and SharePoint Hybrid configuration as well as the process for migrating to Microsoft SharePoint Online. As the book takes you through strategies and techniques for configuring and managing SharePoint on-premises and hybrid scenarios, you’ll get to grips with the concepts essential for SharePoint deployments, such as authentication, Business Connectivity Services, and the data gateway. You’ll also explore migration methods and strategies. By the end of this book, you'll have learned the fundamentals of deploying SharePoint Server 2019 and be able to use this reference guide for your administration tasks.
Table of Contents (19 chapters)

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.
  1. 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...