Excel Task pane does not show

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Benjamin Fallar III - 19 Feb 2008 17:32 GMT

Hi,

We are using VS 2005 and VSTO SE 2005 for creating custom usercontrol task
pane for Excel 2003/2007. It works fine during development and debugging.

Next, we created a packpage/setup project for the task pane, using Setup
project and added the primary output its dependencies and the Excel
template.

Our problem is that after installing it to the client, and opened the Excel
template. The task pane does not appear. I checked the registry that tells
regarding the LoadBehavior, I changed it manually from 2 to 3, but it
automatically reset to value 2.

Please advise. I already did some settings on Excel options to trust the COM
add-in and signed the assembly but still it doesn't work.

Reply to this Message

Andrew Wiles - 26 Feb 2008 06:14 GMT

Benjamin

If you set the environment variable VSTO_SUPPRESSDISPLAYALERTS to 0 you
should get some information about why the application failed to load.

The most likely cause is that the Code Access Security is not set so that
Office trusts your application dll. Misha Shneerson's articles on this
subject should help.

http://blogs.msdn.com/mshneer/archive/2006/01/05/deployment-articles.aspx

> Hi,
>
[quoted text clipped - 12 lines]
> Please advise. I already did some settings on Excel options to trust the COM
> add-in and signed the assembly but still it doesn't work.

Reply to this Message

Excel Task pane does not show

Free Magazines