You are currently offline, waiting for your internet to reconnect

The selected Data Analysis tool uses only data from the active sheet if sheets of a workbook are grouped in Excel

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q214029
For a Microsoft Excel 98 Macintosh Edition version of this article, see 192289.
For a Microsoft Excel 97 and earlier version of this article, see 114975.
SUMMARY
Data Analysis tools such as Anova, Fourier Analysis, Histogram, and Ttest, operate by using data from a single worksheet. Therefore, if sheets of a workbook are grouped (multiple sheet selection) the selected Data Analysis tool uses only data from the active sheet.
MORE INFORMATION
You can send the resulting data to a worksheet range, new worksheet, or new workbook. If you choose to send the new data to a new worksheet and you are in group edit mode, new blank worksheets will be created equal to the number of grouped sheets. The first new sheet will become the active sheet and will display the resulting data in a formatted table while the subsequent sheets will be blank with the default formatting.

If you choose to send the new data to a new workbook and you are in group edit mode, the new workbook will have the default number of worksheets without reference to the number of grouped sheets in the original workbook. The first new sheet will become the active sheet and will display the resulting data in a formatted table while the subsequent sheets will be blank with the default formatting.

If you choose to send the resulting data to a range on the active sheet of the group, the active sheet will display the data in a formatted table while the other sheets in the group will display a formatted, empty table. The borders and formatting may not be the same as the table in the active sheet. In Microsoft Office Excel 2003 and in earlier versions of Microsoft Excel, you may remove this empty table if you select the table cells, point to Clear on the Edit menu, and then click All. In Microsoft Office Excel 2007, you may remove this empty table if you select the table cells, point to Clear in the Editing group on the Home tab, and then click Clear All.

Because you can only perform the Data Analysis function on one active sheet at a time, the resulting data will appear on one sheet only. No data will appear on subsequent created sheets.
Tool Pack Addin atp XL2000 XL2002 XL2003 XL2007
Properties

Article ID: 214029 - Last Review: 01/24/2007 02:54:14 - Revision: 4.1

Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002 Standard Edition, Microsoft Excel 2000 Standard Edition

  • kbhowto KB214029
Feedback