Page 511 - Excel 2013 All-in-One For Dummies
P. 511
Sharing Your Workbooks Online 493
To create a link to a workbook open in Excel 2013 that you’ve saved on your SkyDrive, you select the Get a Link option on the Share screen in the Backstage view (Alt+FHL).
To create a view-only link that doesn’t allow online editing, you then click the Create Link button to the right of the View Link option that appears on the right side of the Share screen under the Get a Sharing Link heading. To create an edit-type link that enables online editing instead of a view-only link or in addition to it, you click the Create Link button to the right of the Edit Link option in its place.
Excel then displays the long and complex hyperlink for sharing your work- book under the View Link or Edit Link heading (depending upon which Create Link button you selected). The program also displays a list of any people with whom you’re currently sharing the workbook (using the Invite People option as described in the previous section) under a Shared With heading as well as buttons indicating that anyone with a view link can view the workbook or with an edit link can edit it under a Shared Links heading.
After creating a view link or an edit link for a workbook on your SkyDrive, you can select the entire hyperlink simply by clicking in the Get a Sharing Link section of the Share screen, and then you can copy it to the Clipboard (Ctrl+C). After copying it to the Clipboard, you can insert it into a new e-mail message (Ctrl+V) that you send to all the people with whom you want to share the Excel workbook to which it refers.
Posting links to social networks
In Excel 2013, you can now post a view-type link to any workbook on your SkyDrive you want to share with friends and followers on any of the social networks, such as Facebook, Twitter, or LinkedIn, to which you’re a member.
To do this, open the workbook saved on your SkyDrive that you want to share. Then, select the Post to Social Networks option on the Share screen (Alt+FHN). Excel then displays the names preceded by check boxes for each of the social networks to which you are a member under the heading Post to Social Networks on the right side of the Share screen.
You then select the check box for each social network to which you want to post a link to your workbook on your page for your friends and followers. If you want to add a message about the worksheet you’re sharing, enter the text below in the Include a Personal Message with the Invitation text box. Then, click the Post button to post the link and any included message to your personal or company page in each of the selected social networks.
Book IV Chapter 4
Sharing Workbooks and Worksheet Data