Spreadsheets usually attempt to automatically update cells when the cells they depend on change.
Spreadsheets have evolved to use scripting programming languages like VBA as a tool for extensibility beyond what the spreadsheet language makes easy.