Microsoft Office Click-to-Run and Dynamics NAV

Microsoft Office has a very interesting feature called Click-to-Run. It is a new software delivery mechanism. Click-to-Run is a new way of delivering and updating Microsoft Office to broadband customers using Microsoft virtualization and streaming technologies."Office apps like Excel and Word aren't directly installed on the computer and rather on a virtual file system not […]

Microsoft Office has a very interesting feature called Click-to-Run. It is a new software delivery mechanism. Click-to-Run is a new way of delivering and updating Microsoft Office to broadband customers using Microsoft virtualization and streaming technologies.

"Office apps like Excel and Word aren't directly installed on the computer and rather on a virtual file system not accessible by a Windows user (not even admin). You can continue to use Excel, Word as you know them but when it comes to Exporting to Office from NAV, we've a problem. NAV cannot seem to locate Excel and throws an error instead "It isn't possible to locate the program "Microsoft Excel’ on your computer. Contact you system administrator."

Why does this happen? Simply because NAV tries to locate Excel in the registry with it's otherwise default install path i.e. C:\Program Files (x86)\Microsoft Office\EXCEL.exe but with Click-to-run this path doesn’t exist since it's managed by CVH.exe (a Virtual Handler) and the target path for Excel then becomes something like this: "C:\Program Files (x86)\Common Files\microsoft shared\Virtualization Handler\CVH.EXE" "Microsoft Excel 2010 9014006204090000"

So how do we fix this? There're a couple of methods but nothing as straight as installing an Office Professional edition. Click-to-run is delivered with Home and Business edition and if you plan on using it with NAV then it's best to avoid the Home and Business edition. Recommended edition of Office for NAV would be Office Professional edition. This isn't elaborated on the System requirements but we're pushing for that to happen," explained Microsoft.

More Info: Click-to-Run | Click-to-Run: Switch to using an MSI-based Office edition