Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!


Free Excel Forum

Compare And Merge Workbooks In Excel

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I am using Microsoft Excel 2002.

I want to Compare and Merge two Workbooks, but when I go to the Tools Menu, the option is shaded. What should I do?

View Answers     

Similar Excel Video Tutorials

Helpful Excel Macros

Combine Multiple Workbooks into One
- This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one new workbook and workshe
Filter Data in Excel to Display Results that Contain 1 of 2 Possible Values - AutoFilter
- This Excel macro filters data in Excel to display results that contain 1 of 2 possible values. This macro uses the xlor
Close a Workbook after a Time Limit is Reached
- This macro will automatically close the workbook in which it is located after that workbook has been opened for a certai
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
- Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a great little macro that allows yo
Sort Worksheet Tabs - Ascending or Descending Order
- This macro will sort all of the worksheets in the current workbook. It can sort in ascending or descending order. This

Similar Topics

I am trying to merge 2 workbooks, again something I do on a daily basis
almost. I have followed the directions given by Excel Help, but I can not
click on the Compare and Merge Workbooks option on the Tools menu. Is there
another way that I can do this without having to move back and forth between
the 2 workbooks?

I want to merge 2 excel workbooks, there is no compare and merge workbooks on
the tools menu. I tried to add the command to the category - no luck. I can
drag the command to the top of the page but it is 'grayed out' and i can't
use it.
Is there another way to get to the 'select files to merge into current

I need to merge two excel files that have my customer lists. I do not see
the following option on the drop down menu so I am puzzled as what to do.
I'm running excel '02. Also, I do not want to merge duplicate contacts.
Your help would be appreciated.

Thanks, victor
1.. On the Tools menu, click Compare and Merge Workbooks.

I have several folders with about 30 workbooks in each that I want to merge and so far have managed to work out how to do one at a time. In my workbooks my Tools, Compare and Merge Workbooks is greyed out. I'm using 2003. Is there any other way I can merge a quantity of workbooks in one go?
Many thanks for your continuing support & help,

I want to Compare two Excel Spreadsheets to highlight the changes that have
been made between one and the other.

Unfortunately the "Compare and Merge Workbooks" function in the Tools menu
is greyed-out. It's not an Add-In, and I've tried installing the
functionality from the CD, but can't find anything.

any ideas?


Paul Wilson

Has anyone successfully used the "Compare and Merge Workbooks" option in
"Tools" in Excel 2003 (Professional)?
It is "unselectable" -- new technical term. :-)
I have tried opening one of the workbooks, both workbooks, no workbooks --
the option always appears to be unselectable.
This is not a "disabled item" on my system.

"My Compare and merge workbooks" is not on the list under "tool" on my toolbar.

any suggestions?


correction: My compare and merge workbooks" is not enabled on my "tools" list...


Merge Work Books-Excel 2003 (Help) explains how to Merge Work Books.It states-Go to Tools and click Compare and Merge Workbooks.
However,when the drop down wind appears the Merge Workbooks icon is disabled. Question is Why -Do I need to download an update?
Please HelpMerge Workbooks

Hello All,
I am pretty new to excel, we get a helpdesk report in xls format consisting of different fields, as most of you must be aware each helpdesk case has a Resolve SLA & Response SLA, referring to the attached, I want to do the following.
1. Compare A2 & A3 & merge if contain same data
2. Compare B2 & B3 & merge if contain same data
3. Compare C2 & C3 & merge if contain same data
4. Compare D2 & D3 & merge if contain same data
5. Compare E2 & E3 & merge if contain same data
6. Compare F2 & F3 & merge if contain same data
7. Compare G2 & G3 & merge if contain same data
8. Compare H2 & H3 & merge if contain same data
9. Compare I2 & I3 & merge if contain same data
10. Compare J2 & J3 & merge if contain same data
11. Compare K2 & K3 & merge if contain same data

I have an excel sheet with about 30000 records of attached sample.
Any help would be a life saver, requesting your assistance.

Sachin Palav

I'm trying to use the Tools menu / Compare and Merge Workbook feature, but it's greyed out and don't understand why. Has anyone used this feature?
What am I doing wrong?

I need to merge two workbooks together. They are saved in the same folder with different names but the "compare and merge workbooks" option isn't available. What do I need to do so I can merge them?

Hello! Some copies of excel workbooks are made using save as option for data entry purpose. Each copy has same file structure because they are created using save as option. Is it possible to merge them (preferably preserving the macros) ? The workbooks are not shared because they were protected sheets and so macros wont run.

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.

Hello all,
I'm wondering if it's possible to be able to have several shared workbooks open and still be able to Compare and Merge those workbooks.

My setup is this: From a shared drive users will access one of several shared workbooks. Ideally I'd like to those workbooks to be able to Compare and Merge even though they are open. Does anyone know if this is possible?

Thank you

Dear all,

I sent out an excel file to other colleagues of my in different countries to
update some figure. after getting the revised version, i try to used the
Compare and Merge Workbooks function in Excel to consolidate the data. But
while doin it on some file, I been kick out from Excel and "Send Error
Report" dialog box been prompt.

Had anyone have any idea to solve this error. Thank.


Excel 2002-2003. How do I programmatically merge two or more workbooks. How
do I manually merge two or more workbooks. Thanks for any help.
Dr. Doug Pruiett
Good News Jail & Prison Ministry

I'm trying to use the "Compare and Merge Workbooks" command for the following

I've duplicated a "master" file in the same folder and renamed it
say,"Fred". The merge workbooks command works just fine between the two files
for now. Then I emailed the "Fred" file off to another company to make
changes. The file was then emailed back to me and I replaced the original
"Fred" file with the returned one.

The problem I have is that I can no longer use the "Compare and Merge
Workbooks" command.

Is there a way to "remerge" files that have been separated like this?


Good Morning;

I have 2 large excel documents; approximately 3,000 rows each; they are similar, but not exact duplicates. (1 is from corporate; 1 is from a branch); I need to create 1 file with both sets of data in it; and there are multiple duplicates. Compare and Merge can't do this because they are not shared workbooks. When I share them I get an error message stating that there hasn't been enough history to compare and merge. Import is messy; and I like the idea of creating an Access database, however this is something that needs to be merged and updated monthly; and personnel will not know how to pull this information from Access.

Any suggestions?

P.S. I know basic Visual Basic;

Thank you.


I want to merge two workbooks. Compare and Merge is grayed out? What do I
need to do?

"into the current workbook."
Yes, trying to Merge and Compare workbooks. Sent out exact copies all shared. It seems a user has done something.
I think if I read this error too many times my head will crack.

I thought I found the issue, someone changed the format. Deleted that file. Try to merge again. Still get the error. Only clean copy I had was the email I sent to them which was the exact one. Could somehow this have messed up? What does this mean? I have 30 workbooks to merge.

I know that I cannot compare and merge a protected workbook but if I make a
copy of the data in the spreadsheet and save it with a differnt name, it
stills doesn't allow me to merge the two.

I have a folder that contains about 1700 workbooks, each workbook containing one worksheet. There are 1-2 workbooks for each group and I need to merge those workbooks together. I have seen code that will merge every book in the folder, but I need to only merge ones for each group.



should become


Not all of the locations have both workbooks, but none of them have more than 2 workbooks.

Can anybody help me to automate this with either VBA or .Net?


GlacierWe are using Office/Word XP, but needed to upgrade our mail server to Exhange 2003...therefore we upgraded all users to Outlook 2003. We have one huge Outlook address book, from which everyone could mail merge from using the Mail Merge Option in the Tools menu. Since the upgrade the mail merge option is now longer available, assuming that there is some kind of conflict between the two programs. I could re-train everyone to start in Word to accomplish their mail merge, but there are still some problem with that process.

Do you think that MS will be correcting this problem in the near future. I've check everything that I could find in Knowledge Base and at but have found no mention of the problem. Is it possible that their is something wrong on our end?

Thanks - I appreciate your help,

Lorrie White @

Hi, I'm using Excel 2003. I'm comparing a list of names in 2 different workbooks. I had to take the first list of names from workbook1 that had last name in one cell and first name in the other cell and merge the data so in one cell I had last name first name. The other workbook[2] has last name first name in one cell.

When I try to do a =MATCH(A1,[Book2]Sheet1!$A:$A,0), I get an error. I believe it's b/c of the merge of last name first name in workbook1. It's like it's not reading the data that was merged into one cell.

Is there another way to do this so I can do the compare and return the matching names? Any advice would be greatly appreciated!!

Hey everyone,

I've trying to sort something out.

My team has got 5 workbooks, all pretty much the same layout, but all with different data as they cover different areas of the country.

However i need to merge all the data into one spreadsheet. None of the worksheets/workbooks are shared documents as if they were i would just use the 'Merge Workbooks' option.

Does anyone know any quick way of merging them into one or am i going to need to set up a whole load of formulas for each cell (there are about 2500-300 rows in each worksheet so would take me for ever)
The main thing I'm worried about also is that any duplicates will be deleted, i need all the data including any duplicate as someone of the information might be different.

Can anyone point me in the right direction.