C# Excel Add-in works on some machines, but then not others

A

aaronfude

Hi,

I've working on an Excel Add-in written is C# that someone else has
started and I have been modifying. It is based on the .Net Framwork
2.0

All of a sudden, the add-in stopped working on my machine and several
others, but still works on a bunch of other ones.

The symptoms are these:
The plugin installs and when you go Tools->Add-Ins->Automation it is
there. Furthermore, upon selecting it, it adds itself to the list of
add-ins. *
However*, the functions defined in it are unavailable in Excel. If you
try to use one, you get "#NAME?". If you select the function dialog,
the functions are not on the list, nor is the add-in under "Or select
a category".

We are at a total loss and any help would be greatly appreciated. This
is really killing our productivity.

Thank you!

Aaron Fude
 
E

Eric

I would appreciate any suggestions whatsoever!
Click to expand...

Since you put it that way, I'll venture a guess. Could it be related
to security settings on the PC? I know you have to take extra measures
to allow a PC to run a VBA script inside a spreadsheet.

If your networking people are anything like ours, they probably
decided to lock down some permissions without coordinating first.
That's a weekly occurance at my company :-(

Eric
 
A

aaronfude

!!!!Yes!!!!

Thank you Eric.

This is some kind of a glitch, because my Macro Security was already
set to Low and I had checkmarks for "Trust all installed templates and
add-ins" and "Trust access to Visual Basic" projects, but unchecking
those and then rechecking them revived by c-sharp Add-in!

Once again, thank you. This has taken months!

(Was there a more systematic way to catch something like this? Is
there an error log or console of some kind?

Aaron
 
E

Eric

(Was there a more systematic way to catch something like this? Is
there an error log or console of some kind?
Click to expand...

Maybe the Windows Event Log had some kind of useful tips about a
security problem? But there's a good chance it didn't show anything
useful. Addins in general are difficult to debug.

Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

C#/Excel automation add-in not working on MediaCenter? 3
start excel from c# and load add-ins 2
Add-in stopped working 1
Works on my pc but not others 5
Order of Excel Add-ins. 10
Excel Add In 1
Command button works for some users but not others 2
CSV code works on some, but not all machines 3

Top