Formula result = Volatile

  • Thread starter Thread starter Miket6086
  • Start date Start date
M

Miket6086

Formula result = Volatile
I can't find a definition anywhere for the word "Volatile" as a formul
result. What does it mean?
 
Thanks! If I use the the "Application.CalculateFull" will this preven
the formula from giving a result of Volatile and is it the same thin
as CTRL+ALT+F9? If so how do I apply it to the whole workbook?
...Thanks again
 
You may be thinking of the indication
that the workbook has been saved, which will
remain in effect until something else triggers
a change activity, or until the workbook is closed.
Turning of calculation would have a similar effect,
except during open and closel.

Private Sub Workbook_Open()
Saved = True
End Sub

If a formula contains volatile functions it will
still be volatile. If you use =NOW() it
will not force a recalculation, but each time the time
the workbook is opened or a calculation event is
triggered it will be recalculated.

within a macro you can suppress triggering an|another
event: (typically used within a change event macro)
Application.EnableEvents = False
'-- code i.e. Target.Value = -Abs(Target.Value)
Application.EnableEvents = True

Will show the time from your computer each time
something causes a recalculation. The function
itself does cause a recalculation.

Recalculate all cells on all worksheets in all open workbooks [Ctrl+Alt+F9]
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#calc

This started out as a question on a definition of
Volatile -- what is it that want or don't want to do
and why.
 
Back
Top