Microsoft Office Tutorials and References
In Depth Information
Sharing Your Worksheets
Excel opens the Share screen with the Invite People option selected
(similar to the one shown in Figure 12-6).
2. Click the Type Names or E-mail Addresses text box and then begin
typing the e-mail address of the first person with whom you want to
share the workbook.
As you type, Excel matches the letters with the names and e-mail
addresses entered in your Address Book. When it finds possible
matches, they are displayed in a drop-down menu, and you can select
the person’s e-mail address by clicking his or her name in the list. To
find e-mail addresses in your Address list and add them to this text box,
click the Search the Address Book for Contacts button (to the immediate
left of the Can Edit drop-down list box) and then use the options in the
Address Book: Global Address List dialog box. To share the workbook
with multiple people, type a semicolon (;) after each e-mail address you
add to this text box.
3. (Optional) Click the Can Edit drop-down button and select Can View
option on the menu to prevent the people you invite from making any
changes to the workbook you’re sharing.
By default, Excel 2013 allows the people with whom you share your
workbooks to make editing changes to the workbook that are
automatically saved on your SkyDrive. If you want to restrict your recipients
to reviewing the data without being able to make changes, be sure to
replace the Can Edit option with Can View before sharing the workbook.
4. (Optional) Click the Include a Personal Message with the Invitation
text box and type in any personal message that you want to
incorporate as part of the e-mail with the generic invitation to share the file.
By default, Excel creates a generic invitation.
5. (Optional) Select the Require User to Sign-in Before Accessing
Document check box if you want the people with whom you share
the workbook to have to log in to a Windows Live account before
they can open the workbook.
Don’t select this check box unless you’re giving your log-in
information to the recipient(s) of the e-mail invitation, and don’t give this log-in
information to anyone that you don’t trust completely.
6. Click the Share button.
As soon as you click the Share button, Excel e-mails the invitation to
share the workbook to each of the recipients entered in the Type
Names or E-mail Addresses text box. The program also adds their
e-mail addresses and the editing status of each recipient (Can Edit
or Can View) in the Shared With section at the bottom of the Share