Search notes:

Excel: Volatile functions

The volatility of a function (either worksheet functions or user defined VBA functions) affects when the function is called for formula recalculation purposes.

A volatile function is always called when

The value of any cell changes on the worksheet
One of the F9 recalculation shortcut keys is pressed.

In contrast, the non-volatile function are only called by pressing

ctrl+alt+F9
ctrl+alt+shift+F9

Volatile worksheet functions include

cell
info (for some arguments)
now, today
offset
randBetween
sumIf
indirect

A user defined VBA function can be marked (in Excel, that is) to be volatile with application.volatile.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/Microsof...', 1758201144, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/Microsoft/Office/Excel/functions/_volatile/index(54): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78