Excel 2002 - Cant merge workbooks?

[JDS]

My Help file tells me to:

"On the Tools menu, click Compare and Merge Workbooks."

BUT, that line is grayed out???

What's up??

JDS

 

[Frank Kabel]

Hi
is your worksheet protected?

 

[JDS]

No sir.

Hi
is your worksheet protected?

 

[Dave Peterson]

Is your workbook shared?

From the context sensitive help:

Merge Workbooks:
Combines changes from multiple copies of a shared workbook into one workbook

 

[JDS]

no. is there no way to merge excel files then?

Is your workbook shared?

From the context sensitive help:

Merge Workbooks:
Combines changes from multiple copies of a shared workbook into one workbook

 

[Dave Peterson]

Merge is pretty ambiguous.

You could copy worksheets into the same workbook.

You could copy data from two worksheets into another worksheet.

If you have a nice unique key column, you could use a bunch of =vlookup()'s to
bring values from one worksheet to another.

I think it depends on the definition of merge.