Microsoft Office Click-to-Run and NAV


Microsoft Office has a very interesting feature called Click-to-Run. It is a new software delivery mechanism. Office Click-to-Run is optimized for home users on broadband connections. Programs delivered via Click-to-Run execute in a virtual application environment on your computer. This means that the programs have private copies of their files and settings, and that any changes they make are captured in the virtual environment. You can read more about Click-to-Run here.

Office applications like Excel and Word are not directly installed on the computer and rather on a virtual file system not accessible by a Windows user (not even administrator). You can continue to use Excel, Word as you know them but when it comes to Exporting to Office from NAV, we have a problem. NAV cannot seem to locate Excel and throws an error instead "It is not 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 does not 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 are 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 is not elaborated on the System requirements but we are pushing for that to happen.

You can also instead switch to using an MSI based Office edition using these instructions: http://office.microsoft.com/en-us/excel-help/click-to-run-switch-to-using-an-msi-based-office-edition-HA101850538.aspx


Mohamad Vajid
Microsoft Dynamics NAV
EMEA Customer Service & Support - SMS&P

Comments (5)

  1. Arhontis says:

    Hello,

    I have encounter this error with a customer of mine. What are the "couple of methods" to fix this without installing an Office Professional edition?

    Thank you

  2. Mohamad Vajid says:

    Hello,

    You can follow the link in the post above. You do not require installing the Office Professional edition. You would simply have to download the MSI-based version of the same Microsoft Office edition and the same license can also be used. Steps required are:

    1. Uninstall Click-to-Run from Add/Remove Programs.

    2. Download the MSI-based Microsoft Office edition and install.

    3. If asked for key/license, use the same as obtained for Microsoft Office Click-to-Run edition.

    The other method is to export a stylesheet using a C/AL function and then open the exported file with Office.

  3. rosana345 says:

    Is it clicktoapp an option? http://clicktoapp.com

  4. Adrien says:

    Please let us know the details for the "couple of methods" you reference in your post.  I was frustrated to see that you know of ways to fix this but did not share them with us!

  5. Rich says:

    In case anyone else comes across this whilst looking for a fix to using office 365 published via App-V (Which I'd be very worried is the NAV team say you can't do this). I'm with the 4 people above, and a fix would have been helpful if it was known about.

    The fix I have found (that needs more testing to make sure it is right) is to simply take the path from my Excel shortcut (this points to the local App-v folder for office) and put this into the registry where an installed version of office would.

    My .reg file looked like

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionApp Pathsexcel.exe]

    @="%LOCALAPPDATA%\Microsoft\AppV\Client\Integration\D24C3BDD-8FAD-44D3-998C-933F8F053682\Root\office15\EXCEL.EXE"

    "Path"="%LOCALAPPDATA%\Microsoft\AppV\Client\Integration\D24C3BDD-8FAD-44D3-998C-933F8F053682\Root\office15\"

    "SaveURL"="1"

    "useURL"="1"

Skip to main content