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 |
Compare Excel Workbooks
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 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 |
All times are GMT +1. The time now is 01:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com