Compare Excel Workbooks

[Russ.Dilley]

I have two Excel workbooks with several sheets in each. The workbooks
are essentially the same with the exception of a few equation buried
somewhere within a particular sheet. The changes in the equations are
minor, for example a '+' changed to a '-', but they impact the entire
calculation so all of the cell values are all different between the two
sheets.

I've found a some comparison programs (e.g. 'Excel Compare', '4Tops
Compare'), but they seem to compare the cells values not the
underlying equations. I'm trying to track down all of the equations
that have been modified but I'm missing at least one.

Can anyone suggest a program or method to compare the actual equations
in the cells rather than just the values?

Thanks,
Russ

 

[Jim Cone]

The commercial "XL Companion" Excel add-in, from yours truly, should
do what you want. You can find formula differences only or choose from
several other comparison types. There is a free trial available.
More info at... http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


<[email protected]>
wrote in message
I have two Excel workbooks with several sheets in each. The workbooks
are essentially the same with the exception of a few equation buried
somewhere within a particular sheet. The changes in the equations are
minor, for example a '+' changed to a '-', but they impact the entire
calculation so all of the cell values are all different between the two
sheets.

I've found a some comparison programs (e.g. 'Excel Compare', '4Tops
Compare'), but they seem to compare the cells values not the
underlying equations. I'm trying to track down all of the equations
that have been modified but I'm missing at least one.

Can anyone suggest a program or method to compare the actual equations
in the cells rather than just the values?
Thanks,
Russ