Page 507 - Excel 2013 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 data with other Office programs
✓ Inserting Excel data into Word and PowerPoint documents
✓ Exporting workbooks as PDF, XPS, and HTML (web page) files
Sharing data between Excel 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 SkyDrive, on your SharePoint team site, or in your Dropbox.
In some cases, data sharing involves getting Excel data tables, data lists, and charts into other Office 2013 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, the program supports data sharing in the form of Actions that can bring information into the spreadsheet that’s related to a particular type of data entry, such as a date or a company’s stock symbol. Information imported through the use of Actions can come from local sources, such as your Outlook Calendar, as well as from online sources, such as MSN MoneyCentral on the web.
Finally, you can give people access to worksheet data using programs other than Excel, including Acrobat Reader, the XML Paper Specification Viewer, and their own web browsers by saving the workbook in a special PDF, XPS, or HTML file format.