Microsoft® Office Excel 2003 Inside Out

Combining Changes Made to Multiple Workbooks

Another way to share a workbook is to make a separate copy of the workbook for each person in your workgroup. This might be a good option if not everyone in your group has access to the same network server or there aren't any network or Internet file-sharing options available to you. In this scenario, after all the distributed copies have been updated with each person's changes, someone collects the copies and merges everyone's work into a master workbook.

Merging Workbooks

You can merge workbooks that were created equal—that is, a set of workbooks created from the same master. When you merge workbooks, all changes made to the merged workbooks are merged into the master workbook. Merging workbooks, like ...