Can Statistica automatically recalculate all spreadsheet formulas when data is changed?
Article ID: KB0081809
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.0 and above |
Description
This article describes how to automatically recalculate all spreadsheet formulas when data is changed.
Issue/Introduction
Can Statistica automatically recalculate all spreadsheet formulas when data is changed?
Resolution
1.Under the Data tab, select "Recalculate Spreadsheet Formulas".
2.Select "Auto-recalculate when the data change" check box in the "Recalculate Spreadsheet Formulas" dialog.
Statistica will automatically recalculate all spreadsheet formulas when data are changed in the spreadsheet. Alternatively, press F9 to manually recalculate the formulas in the spreadsheet.
Feedback
Yes
No
Powered by
