Hyperlinks Issue With Latest Version Of Excel 365

We have tested DiffEngineX with the latest desktop version of Microsoft Excel on Windows, which came part of Office 365.

It seems Microsoft has introduced a problem with hyperlinks that was fixed in previous versions of Excel. In Excel 2013, DiffEngineX produced hyperlinks which worked correctly under all conditions.

As you can see in the screenshot below DiffEngineX produces a cell-by-cell listing of each difference. Each difference is associated with four different hyperlinks.

The first two hyperlinks link to copies of your two compared workbooks with the differences highlighted with color.

The last two hyperlinks link to the original, unaltered two workbooks you specified for comparison.

The problem relates to the last two hyperlinks. Under certain conditions, these two hyperlinks will fail to work.

To ensure that the last two hyperlinks work, one of the following two actions should be performed.

  1. Make sure that the two workbooks you want to compare using DiffEngineX are already open in Microsoft Excel before you compare them. OR
  2. After DiffEngineX has finished comparing your two workbooks, use Excel to close the two color highlighted copies of the workbooks being compared.

N.B. The bug with the last two hyperlinks is only seen when the two workbooks you wish to compare are not open in Excel before you use DiffEngineX to compare them.

Report Of Excel cell differences hyperlinked to color highlighted workbooks
Report Of Excel cell differences hyperlinked to color highlighted workbooks

New Software Product To Compare Text

Compare text, source code, XML and scripts and report differences

Earlier this month we released a new Windows desktop software product to report the differences between two items of plain text, such as source code, XML, scripts, news articles and books. It runs on Windows 7, 8 and 10.

It has two text boxes on the main part of its user interface which can accept text copied and pasted from the clipboard or drag-and-dropped from the filesystem. In this way it can compare any sort of text that can be copied to the clipboard. It will also compare hierarchical folders of files against each other.

It is ideal for software developers who want to know what has changed in their files over time. In fact any author will need a product like this at some point!

A free 30-day trial can be downloaded from https://compare-text-files.com/.

If you are not using Microsoft Windows, a subset of the functionality can be found in our web-based, online text compare tool at https://www.diff-text.com/.

 

Version 3.12 Of DiffEngineX Released

Version 3.12 of DiffEngineX was released on 21st November 2016. This version fixes problems with Excel exceptions and errors being intermittently thrown during and after the process of comparing two Excel workbooks. The root cause is due to Microsoft updates to their Windows and Office software.

If you are running 3.04 or earlier, it is not possible to automatically update to version 3.12. Please manually uninstall using the Windows Control Panel->Programs functionality, before installing the new version from here.

Update To DiffEngineX's Digital Signature

Further to Microsoft's announcement that Windows will no longer trust code signed with a SHA-1 code signing certificate, we have released new versions of DiffEngineX signed with a SHA-256 one. Digital signatures allow confidence that software has not been altered in transit and comes from a named publisher.


If you are using version 3.10 you should upgrade to version 3.11 (built on Windows 10) or above.

If you are using version 3.03, or lower, you should upgrade to version 3.04 (built on Windows 7) or above.

If you have purchased version 2, please click here for details on what to do.

Version 3.10 Of DiffEngineX Released

Version 3.10 of DiffEngineX was released on the 31st July 2015. It has the same functionality as version 3.03, but has been built with a later version of Microsoft development software. If you have Excel 2013 installed, you will notice a speed increase of 25% over version 3.03.


As the installation package is different, it is not possible to use the built-in functionality to update from version 3.03 to 3.10. Version 3.03 must be manually uninstalled using the Windows Control Panel->Programs functionality, before installing version 3.10.


We recommend all users upgrade to version 3.10 or later, as these versions will from now on receive the automatic updates.

Comparing Protected Excel Worksheets

DiffEngineX needs to insert blank rows into temporary copies made of the two Excel workbooks it compares in order to get similar regions to line up. Only when the cells have been aligned, is it possible to compare the formulae that reference them due to row insertion and deletion.

As such protected Excel worksheets cannot, by default, by compared by DiffEngineX.

Version 3.03 allows you to specify a password to unlock protected worksheets and thereby allow DiffEngineX to compare them.

This functionality can be found under Settings->Unprotect Worksheets.

If you are supplying command line arguments you should make use of the below.

/unprotectworksheets:true /unprotectworksheetspassword:"password"