Performs a cell-by-cell comparison of Excel Worksheets.
Spreadsheet Compare (Excel compare) is a Microsoft Excel Add-In, written in VBA, that performs a cell-by-cell comparison of Worksheets within the same or different Workbooks. Requires Excel 2000 or later. Check out the Home Page for more info!
- Perform cell by cell compare
- Perform a database style compare (named columns)
- Generate various reports on differences
Following up on Ashish Jain's comment - where can I download the xlam/xla file? Cannot execute a program to install at work but can install an add-in from the xla.
When I attempt to run the add-in on my 48,000 entry workbook against another 48,000 entry workbook, I get an overflow error. This can be easily fixed by simply dimming "a" as "long" instead of "integer" could you please make this change for me, it would only take literally 5 seconds.
Where is the.xlam/.xla file without password ?
Program doesnt work with Excel 2007
Downloaded Spreadsheet Compare to a 32-bit Vista machine with Excel 2007 and to a 64-bit Windows 7 machine with Excel 2010. When I opened Excel on both machines, got "Automation error. Unspecified error." popup and then got Visual Basic window.