H
Herbert Seidenberg
Why do the Data Analysis tools reference the Personal.xls instead of
the current workbook?
Example:
1. Tools | Data Analysis | Anova... | Input Range:
2. Select A1:A10
3. The Input Range field will show: [Personal.xls]Sheet1!$A$1:$A$10
4. If I unhide the Personal.xls and close it, the Analysis Tool will
reference the current workbook.
Same problem on Excel 2002/Windows ME and Excel 2003/Windows XP.
the current workbook?
Example:
1. Tools | Data Analysis | Anova... | Input Range:
2. Select A1:A10
3. The Input Range field will show: [Personal.xls]Sheet1!$A$1:$A$10
4. If I unhide the Personal.xls and close it, the Analysis Tool will
reference the current workbook.
Same problem on Excel 2002/Windows ME and Excel 2003/Windows XP.