Force to recalculate

[Bura Tino]

Hi,

I am using an XLL (written in C) whose functions retreive some data
off the web. The functions are not Volatile for some reason (can they
be? - if yes, I have access to the source and I can recompile). Is
there a way to force them to recalculate. Pressing F9 doesn't do it. I
need something that would be an equivalent of pressing enter in a cell
when in edit mode!

Many thanks in advance!!!

Bura

 

[Bura Tino]

Hi,

I am using an XLL (written in C) whose functions retreive some data
off the web. The functions are not Volatile for some reason (can they
be? - if yes, I have access to the source and I can recompile). Is
there a way to force them to recalculate. Pressing F9 doesn't do it. I
need something that would be an equivalent of pressing enter in a cell
when in edit mode!

Answering my own question, Crtl-Alt-F9 seems to do what I want.

 

[Ron Bat]

To Have your worksheet recalculate a user function after each inpu
change cell try this:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.CalculateFull
End Su