Microsoft® Office Excel® 2003 Step by Step

Identifying Which Revisions to Keep

Tracking changes lets you and your colleagues modify a document, maintain a record of the changes, and choose which changes to keep in the final version. When every individual with input into a document can’t access the same copy of the workbook, such as if a senior manager is away on a business trip, you can still allow your colleagues input into the final version of a document by sending them duplicates of the original document and then merging the changes in their copies into the original document.

To distribute copies of a document and merge the changes into the original, the files involved must meet these ...