What is the load behavior setting? It sounds like it was configured for Load
On Demand.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Lars" wrote in message
ups.com...
Hello,

I have developed an add-in for Excel which exposes the
IDTExtensibility2 interface in order to obtain a reference to Excel
(needed to add menu entries for initialization). Once initialized, the
add-in provides functions to be used as formulae in a worksheet.

My problem is: the OnConnection method in IDTExtensibility2 does not
get called until I edit a formula provided by the add-in.

I have registered the add-in as an automation add-in. If I register it
as a COM add-in (in the registry), functions are not available for use
as worksheet formulae.

Any ideas ?

Lars