I try to analysis an array [1.. 8192 ], but the toolpak report the
data length must less equal 4096, so there are three question on this
topic
(1)How to extend or substitute with third part tools for excel
(2) can I use data window to extend the range,
(3) if (2) is possible, how to combinate the output data?



Thank you very much!

Zhu

This is an array formula limit in Excel, not the ATP. Your options are to
use another tool or wait for Excel 2007
http://blogs.msdn.com/excel/archive/...26/474258.aspx

Jerry

" wrote:

I try to analysis an array [1.. 8192 ], but the toolpak report the
data length must less equal 4096, so there are three question on this
topic
(1)How to extend or substitute with third part tools for excel
(2) can I use data window to extend the range,
(3) if (2) is possible, how to combinate the output data?



Thank you very much!

Zhu

Excel 2007 (:- it is too later.
Let me try to look others tools. Thank again.

Zhu