Sage Intelligence with Excel 2019

Sage Intelligence has been tested at high level and found that it works with Excel 2019. However, issues may arise from consistent Microsoft updates. In those cases we will determine cause and method for resolving. 

In one example, a Microsoft update to Excel broke .NET functionality in Sage Intelligence. This was fixed in the next update and as a result we request that our customers keep on the latest version and software update of Excel. In this case the attached error was received: 

After extensive testing, we found the customer was using different versions of Excel, and the new update was causing issues within Microsoft Windows.

In some cases an uninstall (using Revo) and reinstall of Excel to the latest version would fix, whilst in other cases the issue would remain. This is due to updates released by Microsoft which corrupts the Windows registry.

 In a similar case, we had a customer with the issue persisting. We asked the customer to format (wipe their PC clean) then reinstall windows.  This worked. The clean install wiped out all of the corrupted files in the registry, the ERP software and Excel (latest version was installed) this worked without any issues.

 Customer's Excel needs to be on the latest version as per screen shot attached.

 

 

Windows updates, all must be installed with the latest updates.