Can STATISTICA automatically recalculate all spreadsheet formulas when the data change?
Yes, by setting the option Auto-recalculate when the data change in the Recalculate dialog (accessed by pressing the Recalculate button in the toolbar), all spreadsheet formulas will be automatically recalculated when the data are changed in the spreadsheet. Alternatively, you can press F9 in the program in order to manually recalculate the formulas in the spreadsheet.
Yes. Select the Auto-recalculate when the data change check box in the Recalculate dialog (accessed by clicking the Recalculate button on the toolbar or selecting Recalculate from the Data menu). STATISTICA will automatically recalculate all spreadsheet formulas when data are changed in the spreadsheet. Alternatively, you can press F9 to manually recalculate the formulas in the spreadsheet.
