Compare and Merge Workbooks in Excel

**colin41** · 03-21-2007, 06:26 PM

I am using Microsoft Excel 2002.

I want to Compare and Merge two Workbooks, but when I go to the Tools Menu, the option is shaded. What should I do?

**VBA Noob** · 03-21-2007, 06:36 PM

Hi,

This link may help

http://office.microsoft.com/en-us/ex...CH010003671033

VBA Noob

**colin41** · 03-22-2007, 07:08 PM

Thank you for responding to my post.

I went to the site but this does not help me. It has the same instructions that are in the Excel Help.

As I mentioned in my previous post, when I go to the Tools menu, the Compare and Merge Workbooks option is shaded, i.e. in grey and not black. So I cannot click on it. I want to know how to make that option black so I can complete the Compare and Merge function.

Thanks.

**davesexcel** · 03-22-2007, 07:09 PM

Originally Posted by colin41

Thank you for responding to my post.

I went to the site but this does not help me. It has the same instructions that are in the Excel Help.

As I mentioned in my previous post, when I go to the Tools menu, the Compare and Merge Workbooks option is shaded, i.e. in grey and not black. So I cannot click on it. I want to know how to make that option black so I can complete the Compare and Merge function.

Thanks.

Is your sheet protected??

**Paul** · 03-22-2007, 09:57 PM

I'm pretty sure that option is only available when you're merging two 'shared' workbooks (two versions of the same shared workbook, too).

**colin41** · 03-24-2007, 04:51 PM

Thank you davesexcel and pjoaquin.

I don't understand what you mean by the sheet being protected. Also, I am not using a shared workbook, just my home computer.

I have the two separate workbooks in the same folder, of course with different filenames, and want to combine the data into one new workbook. Is there any way to get around the problem of having the gray option?

Thanks for any help.

Colin

**Paul** · 03-24-2007, 06:16 PM

Let me rephrase:

You cannot use the "Compare and Merge Workbooks" function unless the two workbooks are both Shared Workbooks, and one of the two is a "child" of the other one (meaning it was an exact copy of the shared workbook for use on another PC, or just separately). You can then compare these two kindred files and merge them.

If your two workbooks are unrelated such that they are not shared workbooks, and one isn't a 'child' of the other, then you'll have to copy the data from one book to the other either manually or through the use of a macro/vba.