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