I am getting the following message when attempting to Merge spreadsheets in
Excel 2002...

{Spredasheet Name} cannot be merged into the current workbook. Workbooks to
be merged must be copies made from the same shared workbook, and must all
maintain the change history for a sufficient amount of time.

Let's see...
1.) I properly created a "Copy" of each spreadsheet.
2.) I went into Tools == Share Workbook and ensured the Allow changes by
more than one user at the same time was checked for both copies of the
workbooks I'm trying to Merge.
3.) I went into the Advanced tab within Tools == Share Workbook and ensured
the radio for Keep Change History for was checked

Now my column headings don't match and I want to merge based on a key...An
Application Number. My good file has close to 15,000 rows. My sub-set file
has 5,000 rows. So I want to see where the 5,000 rows match-up with my big
file of 15,000.

I am all wet thinking that the Compare and Merge function within Excel will
do this for me???

Thanks in advance for your help.