Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to force Excel to close workbooks independently? | Excel Discussion (Misc queries) | |||
How do I Compare and Merge Workbooks in Excel? | Excel Discussion (Misc queries) | |||
How can I compare Excel files | Excel Discussion (Misc queries) | |||
How can I compare the contents of two Excel files? | Excel Discussion (Misc queries) | |||
Tools/Compare and Merge Workbooks - Excel 2003 Pro | Excel Worksheet Functions |