Sharing Workbooks and Worksheet Data
In This Chapter
Sharing online workbooks with clients and co-workers
Sharing Excel 2016 data with other Office programs
Inserting Excel 2016 data into Word and PowerPoint documents
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, ...