Force to recalculate

  • Thread starter Thread starter Bura Tino
  • Start date Start date
B

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
 
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!
Click to expand...

Answering my own question, Crtl-Alt-F9 seems to do what I want.
 
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
 
Back
Top