O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 is a good option if not everyone in your group has access to the same network server, if some users need to work on the workbook when they are on the road, or no network or Internet file-sharing options are 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.

You can merge workbooks that are 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required