Page 488 - Excel 2013 All-in-One For Dummies

470 Workbook Sharing 101
In place of a signature line, you can add a digital stamp (traditionally, in Asian countries such as China, Japan, and Korea, authorities sign a document not with a written signature but by affixing their official stamp to the document, usually in red ink). To literally add your stamp of approval, rather than your signature, to a workbook, choose the Stamp Signature Line option from the Signature Line button’s drop-down menu on the Insert tab of the Ribbon. You then follow steps very similar to those previously outlined for adding a digital signature line, except that you must select a graphic file that contains the image you want stamped in the workbook in lieu of your signature.
Workbook Sharing 101
If you save your workbooks online on your SkyDrive or use Excel on a com- puter that’s connected to a local area network, you can share the spread- sheets that you create with others who have Internet or network access. Workbook sharing is perfect for spreadsheets that require frequent or regular data updates, especially for those whose data comes from several different departments, such as spreadsheets that track budgets or schedule projects that rely on input from many departments.
By sharing a workbook, you enable several people to edit its contents at the same time. Most often, you facilitate this process by saving the workbook file in a folder on your SkyDrive and then sharing the workbook (see Book IV, Chapter 4 for details) or local area network drive (often mapped to a drive letter) to which everyone who needs to edit the spreadsheet has access.
You can share an Excel workbook on a local area network in one of two ways:
✦ Set up file sharing for the workbook by clicking the Share Workbook command button on the Ribbon’s Review tab (Alt+RW).
✦ Turn on change tracking for the workbook by choosing the Highlight Changes option from the Track Changes command button’s drop-down menu on the Ribbon’s Review tab (Alt+RGH).
Whenever you share a workbook using either of these two methods, Excel automatically saves your workbook under the same filename with the shared information. The program then indicates that the workbook can now be shared by appending [Shared] to the workbook’s filename as it appears on the title bar of the Excel program window. When a second person on another computer on the network opens the shared workbook file, Excel opens a copy of the workbook file and the [Shared] indicator also appears on the title bar of his or her Excel program window appended to its filename.