Can STATISTICA automatically recalculate all spreadsheet formulas when the data change?

Yes. Select the Auto-recalculate when the data change check box in the Recalculate Spreadsheet Formulas dialog box.

To access this dialog box:

Ribbon bar. Select the Data tab. In the Transformations group, click Recalculate.

Classic menus. Click the button on the Spreadsheet toolbar or select Recalculate Spreadsheet Formulas from the Data menu.

Statistica automatically recalculates all spreadsheet formulas when data are changed in the spreadsheet. Alternatively, you can press F9 to manually recalculate the formulas in the spreadsheet.