ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Comparison program? (https://www.excelbanter.com/excel-discussion-misc-queries/122239-excel-comparison-program.html)

Ben

Excel Comparison program?
 
Hi all. I am looking for an Excel comparison program that will check 2 Excel
files to see if any of the formulas have been changed or are different
between the two. I don't need a comparison of the individual cells but if
that feature is part of the package that would be ok.

Anyone have any suggestions?
--
Thanks for your help!
Ben

Dave F

Excel Comparison program?
 
One possibility would be John Walkenbach's power utility pak. Just google
his name; you'll find it easily enough.

It has a formula auditing tool which spits out a report of all formulas used
in a worksheet.

I suppose you could compare the two reports.

Dave
--
Brevity is the soul of wit.


"Ben" wrote:

Hi all. I am looking for an Excel comparison program that will check 2 Excel
files to see if any of the formulas have been changed or are different
between the two. I don't need a comparison of the individual cells but if
that feature is part of the package that would be ok.

Anyone have any suggestions?
--
Thanks for your help!
Ben


CLR

Excel Comparison program?
 
I use Jim Cone's fine commercial Add-in called XL Companion. It's available at

http://www.realezsites.com/bus/primitivesoftware/

Vaya con Dios,
Chuck, CABGx3



"Ben" wrote:

Hi all. I am looking for an Excel comparison program that will check 2 Excel
files to see if any of the formulas have been changed or are different
between the two. I don't need a comparison of the individual cells but if
that feature is part of the package that would be ok.

Anyone have any suggestions?
--
Thanks for your help!
Ben



All times are GMT +1. The time now is 06:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com