Using Data Analysis Tools on Grouped Sheets (114975)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Excel 97 for Windows
This article was previously published under Q114975 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. You may remove this empty table if you select the table cells,
point to Clear on the Edit menu, and then click 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.
| Modification Type: | Minor | Last Reviewed: | 8/15/2003 |
|---|
| Keywords: | kbinfo kbualink97 KB114975 |
|---|
|