Excel 2016 All-in-One For Dummies

Chapter 4

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