Comparing Models

[Adam]

I have an excel financial model that I recently made
changes to. I want to compare an older version of the
same model to the new version to see what changes I made.
Is there an easy way of doing so? There are a lot of
behind the scenes formulas in this model that I
periodically update. A collegue in my office used an
older version to do a financial analysis and I'm concerned
about it not reflecting the updates. Thanks.

 

[Dave Peterson]

Cell by cell comparison (a1 with a1, z52 with z52???).

If yes, you could use Myrna Larson and and Bill Manville's addin.

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