Deployment of ClickOnce VSTO document-level Excel app for all users. Trusted location issue RRS feed

  • Question

  • I have released signed document-level VSTO app by ClickOnce. I use my own untrusted certificate. It's app distributed among university students.

    On some computers we encounter a problem with trusted location, so the app cannot be installed there.

    I found advices to set trusted location (even with subfolders) via Excel on end-user PC. It unfortunately does not help (even with PC restart). I have found advices to set some values registries which sounds a bit nerdy (as I got used to comfortable and direct release via ClickOnce).

    I would like to avoid preparing Windows Installer or buying trusted certificate.

    Any help? Thank you.

    VSTO is very powerful concept, but the deployment part is really frustrating (compare to old-school VBA from user view).

    Monday, December 9, 2013 10:30 PM


  • Hi Daniel,

    >>On some computers we encounter a problem with trusted location<<

    What's the problem? Is there any message popped up?

    According to Granting Trust to Documents:

    There are several security concerns when you consider which folders to add to the trusted locations:

    • Local folders are considered to be more secure and are implicitly trusted. Remote locations such as file shares must be designated as trusted locations.
    • When you add a directory to the trusted locations, this action grants full trust not only to Office solutions, but also to VBA and ActiveX code. For this reason, the root directory and the My Documents folders should not be designated as trusted.
    • Although the document itself is trusted by using the trusted locations, additional permissions are needed to trust the customization. You can grant full trust to the customization by using signing the manifests with a certificate, clicking the trust prompt, or installing the Office solution to the Program Files directory.
    • You can store the document or workbook of a document-level solution in the same directory as the assembly, or in a different directory. For example, the document could be located on a SharePoint server and the assembly could be located on a network file share. For more information, see How to: Publish a Document-Level Office Solution to a SharePoint Server by Using ClickOnce.

    You can try these steps above.

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by Daniel Stastny Monday, December 16, 2013 10:10 PM
    Friday, December 13, 2013 5:17 AM