Excel change compare

[LeeAnn]

I need to compare two Excel documents and list out the differences between
the two. I did not find any Out of the Box (OOTB) capability in Excel to do
this. Are you aware of any 3rd party OOTB tools that will provide this
capability?

-Thanks

 

[Sean Timmons]

Depends on what you are looking for when you mean differences. Are you
talking any and all diferences from one workbook to another? Don't know of
anything that covers that at all.

If you are looking for changes by sheet, you could actually just use VB
programming to compare cell by cell...

 

[ShaneDevenshire]

Hi,

There is no feature built into Excel to do this, but people have create
them. Try Googling Compare Excel Files


If this helps, please click the Yes button.

 

[Gord Dibben]

The add-in, Compare.xla written by Myrna Larson and Bill Manville, allows
you to compare the contents of two workbooks and highlight differences.

http://www.cpearson.com/excel/whatsnew.htm

Look for Compare.xla at 14-June-2000

Download Compare.ZIP, unzip Compare.xla and add it to your Office\Libray
folder.

On Tools Menu, select add-ins and checkmark Compare Worksheets.
From tools menu then select Compare Sheets and follow instructions.


Gord Dibben Excel MVP