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

Chapter 26. Using Excel in a Workgroup > Consolidating Data from Multiple Users...

Consolidating Data from Multiple Users into a Single Workbook

So far, we've discussed sharing workbooks and tracking revisions on a shared workbook file users open from a central location on a company network. But revision tracking can be useful in another set of circumstances as well. You can create a workbook, turn on revision tracking, and then make copies and distribute them to a group of people. If you want a group of department heads to work on draft budgets, for example, give each one an identical workbook with revision tracking turned on. When they return the copies with their changes, you can merge the copies into a single workbook, and then review and accept or reject individual changes.

Tip from

If there is any chance that the process of distributing, collecting, and merging workbooks will take longer than 30 days, be sure to change the time period you specify to maintain the merge history. Select Tools, Share Workbook, click the Advanced tab, and enter a number of days in the Keep Change History For box. To be extra safe, set this value to its maximum of 32767.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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