• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 19. Collaborating with Excel > Combining Changes Made to Multiple Workb...

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 change tracking, is closely linked with the shared workbooks feature; you can merge only workbooks that have been saved with sharing turned on.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint