Microsoft Office Tutorials and References
In Depth Information
Chapter 14: Collaborating with colleagues
IN THIS CHAPTER, YOU WILL LEARN HOW TO
▪ Share workbooks.
▪ Save workbooks for electronic distribution and as web content.
▪ Manage comments, and track and manage colleagues’ changes.
▪ Protect workbooks and worksheets.
▪ Authenticate workbooks.
▪ Import and export XML data.
▪ Work with SkyDrive and Excel Web App.
Even though one individual might be responsible for managing an organization’s
financial data and related information, many people provide input about revenue projections.
You and your colleagues can enhance the Microsoft Excel 2013 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 site, 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. By adding password protection, you can prevent changes to critical elements of your
workbooks. You can also hide formulas used to calculate values.
If you work in an environment in which you and your colleagues, both inside and outside
your organization, exchange files frequently, you can use a digital signature to help verify
that your workbooks and any macros they contain are from a trusted source.