Show Me Microsoft Office Excel 2003

For one reason or another, multiple users may maintain identical workbooks. At some point, you'll want to integrate their data into one master workbook, known as the template. First, though, you need to compare the data to identify the differences between the worksheets. Excel can electronically combine the entries, which ensures the integrity of your data. When merging workbooks, all the workbooks must be identical to the file into which the data is being merged. To distribute copies of a workbook and merge the changes into the original, the workbooks must have sharing, change tracking, and change history turned on and use a different file names .

Merge Workbook Data

Open the shared workbook that you want to merge.

Click the Tools menu, and then click Compare And Merge Workbooks.

Click OK to save the workbook, if necessary.

Select the files you want merged with the active file.

To select more than one workbook to merge, press and hold Ctrl, and then click other files.

Click OK.

Click the Save button.

Click the Tools menu, point to Track Changes, and then click Accept Or Reject Changes.

Select the When check box, click the list arrow, and then click Not Yet Reviewed.

Clear the Who and Where check boxes.

Click OK.

Click the buttons to accept or reject changes, and then click Close.