How to Auto-recalculate formulas in Statistica when data changes?
Article ID: KB0082392
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 10 and later versions |
Description
The user wants to auto-calculate formulas when data changes in the spreadsheet without having to click on the recalculate button or re-evaluating the formulas when data changes.
Issue/Introduction
How to Auto-recalculate formulas in Statistica when data changes?
Resolution
1. Open Statistica and click on Tools >> Options in the menu bar while having a spreadsheet open.
2. Navigate to Document >>Spreadsheets
3. Check the option to 'Auto-recalculate spreadsheet formulas when data change'
4. Click Ok and continue using Statistica. This option will be remembered for the user using Statistica
Feedback
Yes
No
Powered by
