Xltrail is a web based tool similar to GitHub that doesn’t just compare 2 Excel files but also keeps a version history of them. Requires to manually set a col/row “primary key” for each sheet Shows spurious changes both for rows and VBA modules Green means that the change has been properly recognized. a set of changes that makes it hard to understand what’s going on. Changing Cell D12 from a formula to a valueĭisappointingly, merged cells and column/row operations make most of the tools unusable as only two ( xltrail and Synkronizer) manage to show the correct changes without manual intervention or without ignoring a change or introducing noise, i.e.We then create a second version ( sales_plan_v2.xlsm) of the workbook by introducing the following changes: We’re starting with a simple Workbook ( sales_plan_v1.xlsm) with some merged cells and a few lines of VBA code. Table of ContentsĮxcel File Comparison Tools Overview Supported File Formats Let’s see what our options are! In the first part of the post, we’re comparing the features of the tested tools before we get into the details of how well each tool is doing with regards to our test case scenario. Accordingly, there are only a few tools available that claim to do the job. The fact that Excel is a two dimensional grid with formulas that contain relative cell references makes it quite a challenge. Comparing text files is easy, but comparing Excel files not so much.
0 Comments
Leave a Reply. |