834
Chapter 29 Using Excel in a Workgroup
3. Confirm the password you just entered and click OK. Excel displays the Save As
dialog box.
4. Give the file a name and click Save. This is your master workbook.
5. Without making any changes to the workbook, click File, Save As, and make a new
copy for each person to whom you plan to distribute the workbook. Make sure each
copy is identical, and save each one under a different name.
After you receive the filled-in copies from each co-worker, follow this procedure to merge
the workbooks:
1. Open the master workbook you created before distributing the copies.
2. Select Tools, Compare and Merge Workbooks. If ...