Comparing Two Documents

[Stuart Stevens]

Hi there,

I was on the Word Newsgroup yesterday and posted a query
asking if I could compare two documents if I had the
original and the updated version, and to my amazement I
could (using Tools-> Tracked Changes)!!!!

I am therefore wondering if there was anything similar for
Excel?? I have two documents from an external source -
both of which follow the same layout and have the same
sheets in the same order etc. Is there any way of
detecting what changes have been made since the original
document was issued (i.e. to key inputs and also to
formulae within cells???)

I would really appreciate your help as I am dealing with a
bunch of rogue consultants who are determined to put a
spanner in my firm's works by recommending the wrong
Option Appraisal....

Many Thanks,

Stuart.

 

[Dave Peterson]

It depends.

Myrna Larson and and Bill Manville wrote an addin that compares two worksheets
on a cell-by-cell basis.

A1 is compared with A1. B99 to B99. If one of the users inserted (or deleted)
rows (or columns), then this cell-by-cell comparison breaks down.

Here's a link to the program (kept at Chip Pearson's site):
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

But if one of your consultants inserted a new row 1 (or deleted column A), then
you'd find a bunch of changes right away.