Solved

Excel VB.net/VSTO Add-in gets disabled often

Posted on 2014-12-21
3
181 Views
Last Modified: 2014-12-22
Hi

I have a Excel VB.net/VSTO Add-in  built in Visual Studio 2010.
It gets rolled out to over 70 people.
The problem is that every so often the ribbon disappears and the
add-in gets disabled. Most users don't handle this well.
How do I stop this from happening?
0
Comment
Question by:murbro
3 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 250 total points
ID: 40512705
Normally you should get a warning asking if you want to disable the add-in if Excel thinks it has caused a problem. There isn't really much you can do about that other than try and figure out what the underlying problem is - unfortunately, it may not actually have anything to do with your add-in, in my experience.
0
 
LVL 5

Assisted Solution

by:Leon Kammer
Leon Kammer earned 250 total points
ID: 40512722
Hi,

Could be many things from a corrupted xlb file to network permissions, the office ribbon has been and continues to cause problems since 2007.

Does CTRL+F1 restore the ribbon?

Does the ribbon disappear for files accessed only over the network file share (and for files in protected mode)?;
Does the ribbon disappear for those users on the wireless and wired networks?

Does the ribbon disappear:
When a macro enabled file is opened?;
When a specific file is opened (or does it occur randomly)?;
When opening a file directly (double clicking) as well as when opening a file from within an Excel session?

Cheers

Leon
0
 

Author Closing Comment

by:murbro
ID: 40512868
Thank you both. It looks like the problem isn't going to go away and I should focus on telling users to watch for that prompt
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now