Excel 2016 Bible

Chapter 29Excel and the Internet

IN THIS CHAPTER

1. Saving a workbook to an Internet location
2. Saving Excel files in HTML format
3. Creating hyperlinks
4. Using Office Apps

Most people who use a computer are connected to the Internet. The web has become an important way to share, collaborate, and gather information from myriad sources. To help you with these tasks, Excel has the capability to create files that you can use on the Internet and to gather and process data from the Web. This chapter covers topics related to Excel and the Internet.

Saving a Workbook on the Internet

Excel 2016 makes it easy to save your work to your OneDrive account or to a SharePoint site. Doing so lets you access the workbook from any computer that has Internet access, no matter where you are. And the computer doesn't have to have Excel installed. Sign in to your OneDrive or SharePoint account, and you can download the file and work on it locally or view it (and perhaps do minor editing) directly in your web browser using Microsoft Office Online.

To save a file to the Internet, choose File Save As, and then select OneDrive or SharePoint in the left section of the Save As screen. Click Browse, and choose a directory for the file. If you want, you can share the workbook with others, but only one person at a time can edit the file. You must be signed in to your SkyDrive or SharePoint account to save a file ...