greyed out compare and merge document

[Guest]

I am trying to merge 2 excel workbooks. I am following the directions in Help
but it says to select the Compare and Merge document in Tools menu but it is
greyed out. How do I activate the menu choice?

 

[Peo Sjoblom]

You realize that these have to be shared copies of the same workbook?

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Guest]

No I did not realize that. The instruction in the help files did not mention
anything about shared documents or that they must be the same workbooks. Does
that mean they have to have the same fields in each document?

 

[Guest]

Peo,
I shared the document and now it is not greyed out but can I merge two
different office list into one list where duplicates are deleted?