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
The analysis recalculates and the report updates.