user defined formula calculation after excel launch

D

drew_p

I have created automation add-in in c# VS-2005. This adding contains two
functions
getCommodityFullName(string cmdtyCode)-return commodity name from table and
getCommodityPrice(string cmdty,date dt)-read commodity name from cell which
referencing getCommodityName() formula. I have used this formulas in multiple
cells.
But problem is that when Excel lauch it doesn't refresh these formula
calculation. Is there any reason for that ? I have also used Excel.Volatile()
in these functions. Still no luck.
Thanks
 

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

Excel - Wich Function should I use? 1
INDEX and MATCH 1
Sting to VALUE conversion 3
LOOKUP instead of Index and Match 1
Exceltastic brings back the classic Excel menus 1
Getting #VALUE in cells with User Defined Functions 2
Macro Help for a BIG Calculation 1
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0

Top