greyed out compare and merge document

S

susaneweb

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

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
 
S

susaneweb

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

susaneweb

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top