Comparing and Merging Workbooks

graphics/microsoft55.gif

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

graphics/one_icon.jpg

Open the shared workbook that you want to merge.

graphics/tow_icon.jpg

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

graphics/three_icon.jpg

Click OK to save the workbook, if necessary.

graphics/foure_icon.jpg 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.

graphics/five_icon.jpg

Click OK.

graphics/six_icon.jpg

Click the Save button.

graphics/seven_icon.jpg

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

graphics/eight_icon.jpg

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

graphics/nine_icon.jpg

Clear the Who and Where check boxes.

graphics/ten_icon.jpg

Click OK.

graphics/leven_icon.jpg

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

graphics/12inf12.jpg

graphics/12inf13.jpg

graphics/12inf14.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net