Chapter 29: Excel and the Internet

In This Chapter

Saving a workbook to an internet location

Saving Excel files in HTML format

Creating hyperlinks

Importing data from a web page

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 also 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 2013 makes it very easy to save your work to your SkyDrive 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 SkyDrive 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 the Excel Web App.

To save a file to the Internet, choose File ⇒ Save As, and then select SkyDrive or SharePoint in the Places 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 in order to save a file to one of these locations.

Figure 29.1 shows an Excel workbook that was saved to ...

Get Excel 2013 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.