Recalculating an analysis
Recalculate an analysis when the data has changed, and you want to update the report to reflect those changes.
Note: Be aware that when you recalculate an analysis, the current analysis report worksheet is deleted and replaced with a new worksheet. If you have made changes to the layout or formatting of the analysis report, the changes are lost.
- Activate the report worksheet.
-
On the Analyse-it ribbon tab, in the
Report group, click
Recalculate.
Note: Prior to version 5.10 the active filter is not saved with the analysis. When you recalculate an analysis the rows currently visible are analyzed, regardless of the filter you used when creating the analysis. From version 5.10 onwards, by default the filter criteria are saved with the analysis and re-applied when you recalculate or make other changes to the analysis. The drop-down arrow next to the Filter command on the ribbon of the active analysis lets you change between Use active filter which always uses the currently active filter when recalculating (pre version 5.10 behavior) and Save Filter & Re-apply (version 5.10 or later behavior) which saves the filter when the analysis is calculated and re-applies it on subsequent recalculation.
The analysis recalculates and the report updates.