COMPARE TWO WORKBOOKS

solracesoj

Board Regular
Joined
Oct 25, 2002
Messages
144
In Word is so simply to compare two documents!
In Excel, although I’m trying to compare two WORKBOOKS, there is lot’s of difficulties.

In Excel the option “Compare and Merge Documents” is not highlighted.
So when I go to HELP, I see that:
“Requirements for merging Both workbooks must meet the following requirements:
Be copies of the same workbook, which must have been a shared workbook.
Have different file names.
Either not have passwords, or both have the same password.
Have change tracking in effect continuously from when the copies were made.
Keep change history back at least as far as the date when the copies were made.
For example, if the change history is being kept in the workbooks for 30 days, and the copies were made 45 days ago, you can no longer merge the workbooks.”

So, do I have to fulfill all of this parameters or is there an easier way out?

Thanks in advance

J.C.
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Babydum

Board Regular
Joined
Feb 24, 2005
Messages
164
J.C.

It really depends on what you are trying to do. When you say "compare", if you mean look at the two documents side by side then you can open the two books, then use WINDOWS>ARRANGE.

You can also put formulae in a third book that will look at the differences between two books.

So I guess you will need to give a better explanation of what you're trying to accomplish before a satisfactory answer can be found.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,139
Messages
5,576,308
Members
412,716
Latest member
thviid
Top