I want to merge two workbooks but the option is greyed out. Why?
 

Any ideas?

The Merge Workbooks option is made available when tour workbook is shared.
Then you may merge the changes from one workbook into another workbook but
both workbooks must meet the following requirements:

Both workbooks must be copies of the same workbook. (extract from help file)

BTW could you ask questions in the body of the message not in the subject
line.
"MOC" wrote:

Any ideas?