The answer depends alot on what your data looks like... But normally with
that many rows of data a pivot table is your best solution. Pivot tables can
be used up to a few million rows (when hooked directly to databases) with
remarkably good performance.
--
HTH...

Jim Thomlinson


"Jane" wrote:

I want to analyze data in excel, but the questions it is more than 30000
rows, it runs very slow.who can give me any suggestions on dealing with this
problem?Thanks a lot.