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?

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


"susaneweb" wrote in message
...
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?

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?

"susaneweb" wrote:

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,
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?

"Peo Sjoblom" wrote:

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


"susaneweb" wrote in message
...
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?