add-in not showing in function list in Excel

[joseph_doggie]

I successfully created an Add-in set called "ExcelAddIn2.MyFunctions"; and
added it.


This was following the book "Visual Studio Tools for Office Using C# with
Excel, Word, Outlook, and InfoPath" by Eric Carter & Eric Lippert (sometimes
called Eric2). See especially pp. 88-89 in the 2006 Pearson Education
edition.


However, when I created a new project, e.g. "ExcelAddIn3.TheseFunctions",

I use the Automation function, scroll down the list, and find it.

I check the appropriate box in the "Add-Ins" dialog box (or list box or
whatever form it is).


However, when I use insert->function -> Or Select a category and scroll
down, it is absent.



I also have found the same true of add-ins I've downloaded from the web.
For these, I store in a known sub-directory, then use Tools->AddIns
("Browse" button), find the appropriate file in the subdirectory.



Once again, I check the appropriate box in the "Add-Ins" dialog box, but
similary when I go to insert->function -> Or Select a category and scroll
down, it also is absent.



I've tried removing the "ExcelAddIn2.MyFunctions" -- thankfully it comes
back when I restore it ; I've tried re-booting and so forth.

Does anyonoe have any idea what the problem is?



Also, how does one remove "Add-Ins available" from the aformentioned Add-Ins
dialog box (obtained by using Tools--> AddIns)?



NOTE: I am using VSTO, Microsoft Visual Studio 2008, and Microsoft Office
(Proffesional Edition 2003) including the Microsoft Excel 2003.



Does anyone know of a link (URL) that would help?



Thread discussion: To do anything at all with VSTO, one needs to be able to
use an add-in in the appropriate office program, e.g. Excel. However, if
this thread belongs elsewhere please let me know where I should put it.

In case it matters, I'm using

(using XP Professional 5.1.2600 Service Pack 2 Build 2600)



This is on a dell Desktop computer that is an X86-based PC (GenuineIntel).





The exact MS Office version is 11.8142.8132 SP2



and VS is

MS Visual Studio 2008 Version 9.0.21022.8 RTM with Micorosft .NET Framework
Version 3.5 (c.2007)



There is also C# 2008 and Microsoft Visual Studio Tools for Office 2008.

This is a re-post of a question I asked before, but I am still awaiting an
answer.

Thanks in advance, (-:


Sincerely,

Joseph
a/k/a joseph_doggie

 

[Peter T]

However, when I use insert->function -> Or Select a category and scroll

down, it is absent.

I'm a bit confused by that, what are you scrolling down. When you add an
Automation addin its functions should appear in a new category which for you
is probably called "ExcelAddIn2.MyFunctions". This should appear at or near
the bottom of the categories list in the function wizard, which is displayed
with Insert Function, Shift-F3 or the "fx" button on the input bar. Your
functions should also appear in the "All" category.

If no new category appears, maybe there is something wrong with the addin.
Though I would have thought you would have got a message something along the
lines "this is not an addin" when you tried to add it from the Automation
list.

Also, how does one remove "Add-Ins available" from the aformentioned
Add-Ins
dialog box (obtained by using Tools--> AddIns)?

Simply un-check in the Addins list. To fully remove the entry requires a
registry hack, typically the app's un-installer would do that if it has one.

Regards,
Peter T

 

[joseph_doggie]

Thanks for your help.

To be honest, I already tried your suggestions.

What our company wound up doing is buying "add-in expres" (addin express or
adx)
which does cure this problem.

If anyone knows another way to get the functions to show up -- or why
they're not showing up, please let me know.

I have noticed that sometimes one needs to open and close Excel to get an
add-in to work, there are also registry entries that could be edited/deleted.

Finally, I have noticed a phenomenon that some add-ins do not "play well
together" and that one has to disable or remove other add-ins to get a new
add-in to work.

Hope these ideas help anyone out there who has expierenced these same Excel
add-in problems with their Excel add-in function or functions.

Thanks Again,