Hi all,

I've created a pretty basic VFP com server that fetches some data from various tables & returns a number. (VFP 8 and Excel 2002) I went into Excel's Tools/Add-ins/Automation and selected the new DLL and placed a checkmark in the available column. It's now available from the functions/addi-ins menu & works fine except for the fact that it doesn't want to refresh correctly - even with a recalc sheet or complete workbook. However, if if I go into the contents of the cell and hit enter after the formula, then it recalcs as it should.

To test this, I've closed Excel and changed the calculation to return a different value and rebuilt the com server. When I open up the saved worksheet, the old value is still displayed & again, the only way I can get the cells to recalc properly is to go into the cell formula and hit enter.

Am I missing something really basic?

Thanks for any insight.

-Matt