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.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,627
Messages
5,832,758
Members
430,165
Latest member
Idjaz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top