View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] Russ.Dilley@gmail.com is offline
external usenet poster
 
Posts: 2
Default Compare Excel Workbooks

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