Book Image

Implementing Microsoft SharePoint 2019

By : Lewin Wanzer, Angel Wood
Book Image

Implementing Microsoft SharePoint 2019

By: Lewin Wanzer, Angel Wood

Overview of this book

Microsoft’s latest addition to their product range, SharePoint Server 2019, is a new enterprise content management platform that brings on-premise collaboration features to life. It can be used as an isolated platform or in a hybrid connected configuration providing management and connectivity to Office 365. You can use the SharePoint framework to host sites, information, data, and applications in a robust CMS that centralizes collaborative content for enterprises. SharePoint 2019 enables new integrations and features that will allow you to work seamlessly with new and old Office products such as Microsoft Power Apps and other Microsoft Office applications. Implementing Microsoft SharePoint 2019 will help you understand the challenges, planning, migration steps, installation concepts, and configuration involved in providing this platform for your enterprise. The book will also show you what the platform brings to the table from an on-premise server perspective. If you’re new to SharePoint 2019, you’ll also be guided through how to get servers up and running so that you and your user community can become productive with this powerful new platform. By the end of this book, you’ll be well-versed in Microsoft SharePoint 2019 and have the knowledge you need to apply your skills in the real world.
Table of Contents (14 chapters)

Excel Online

Excel Services has changed immensely and if you offer these services as part of your SharePoint 2019 deployments, there are many changes you need to know about and understand. It was moved outside of SharePoint in the SharePoint 2016 version of the product. Excel Online includes many of the same features Excel Services included in SharePoint Server 2013, such as external data connectivity and data refresh features.

Data refresh in Excel Online is supported only on SQL Server and SQL Analysis Server. There are steps you can follow to setup data refresh, from creating a workbook to setting the workbook's refresh based on the data source. Refreshes can only be triggered in one of two ways:

  • The end user opens the workbook
  • The end user clicks on the refresh button on an open workbook

Office Online Server can communicate with SharePoint servers, Exchange servers, and Skype for Business servers by using HTTPS protocol. This should be the way environments...