Troubleshoot data analysis

Microsoft Excel

Troubleshoot data analysis

Applies to tools in the Analysis ToolPak.

Data appears only on the first worksheet

The data analysis functions can be used on only one worksheet at a time. When you perform data analysis on grouped worksheets, results will appear on the first worksheet and empty formatted tables will appear on the remaining worksheets. To perform data analysis on the remainder of the worksheets, recalculate the analysis tool for each worksheet.