Chapter 4

Sharing Workbooks and Worksheet Data

In This Chapter

arrow Sharing online workbooks with clients and co-workers

arrow Sharing Excel 2016 data with other Office programs

arrow Inserting Excel 2016 data into Word and PowerPoint documents

arrow Exporting workbooks as PDF, XPS, and HTML (web page) files

Sharing data between Excel 2016 and other Windows programs that you use is the topic of this chapter. Perhaps the most straightforward way to share worksheet data is by sharing the Excel workbook saved in the cloud on your OneDrive, on your SharePoint team site, or in a folder in your Dropbox.

In some cases, data sharing involves getting Excel data tables, data lists, and charts into other Office 2016 programs that you use, especially Microsoft Word documents and PowerPoint presentations. In other cases, data sharing involves getting data generated in other programs, such as in tables and lists created in Microsoft Word and contacts maintained in Microsoft Outlook, into an Excel worksheet.

In addition to data sharing that involves bringing data stored in different types of documents into Excel worksheets, ...

Get Excel 2016 All-in-One For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.