Sharing, Reviewing, and Distributing Data

Abstract

In many organizations spreadsheets are often not the work of a sole author but include input from various users, such as the members of a project team. If several people need to be able to edit the contents of a workbook simultaneously, you can create a shared workbook and store it on a network location. You can then control which users should have access to the workbook and resolve any conflicting changes. When collaborating with colleagues on a workbook, it is usually important to keep a record of who edited what and any comments that reviewers have made. In this chapter I will discuss the reviewing features that are available in Excel and how you can track the changes that are made to a document.