Microsoft Office Tutorials and References
In Depth Information
In this chapter, you will learn how to
✔ Share workbooks.
✔ Manage comments.
✔ Track and manage colleagues’ changes.
✔ Protect workbooks and worksheets.
✔ Authenticate workbooks.
✔ Save workbooks for the Web.
Even though one individual might be responsible for managing an organization’s financial
data and related information, many people have input when making revenue projections.
You and your colleagues can enhance the Microsoft Excel 2010 workbook data you share
by adding comments that offer insight into the information the data represents, such as
why revenue was so strong during a particular month or whether a service level might be
discontinued. If the workbook in which those projections and comments will be stored
is available on a network or an intranet, you can allow more than one user to access the
workbook at a time by turning on workbook sharing. When a workbook has been shared
with your colleagues, you can have the workbook mark and record any changes made to
it. You can then decide which changes to keep and which to reject.
If you prefer to limit the number of colleagues who can view and edit your workbooks,
you can add password protection to a workbook, worksheet, cell range, or even an
individual cell. Adding password protection prevents changes to critical elements of
your workbooks. You can also hide formulas used to calculate values.