Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jun 2005
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compare and Merge Workbooks tool (Excel XP)

    I would like to compare and merge 2 different Excel Workbooks. Under the Tools Menu, the "Compare and Merge workbooks" option is disabled. Does this need to be installed separately?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Compare and Merge Workbooks tool (Excel XP)

    The option to Compare and Merge Workbooks is only available for shared workbooks. In my opinion, sharing a workbook is a buggy feature of Excel, it increases the probability that the workbook becomes corrupt, so I don't recommend using it.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Compare and Merge Workbooks tool (Excel XP)

    Chip Pearson has an addin to compare notebooks on his site (Whats New?) that you may fine useful for comparing them.

    Merging is such a broad topic you would have to be more specific on what you mean by "merging" and how you want to combine them.

    Steve

  4. #4
    Star Lounger
    Join Date
    Jun 2005
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compare and Merge Workbooks tool (Excel XP)

    Thanks Steve and Hans. I basically want to show all the differences between the 2 worksheets (like Word's Compare and Merge Feature"). Word shows what has been inserted, and what has been deleted.

  5. #5
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Compare and Merge Workbooks tool (Excel XP)

    Went there and bookmarked that page. Awesome... Thanks
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •