How can I make reports faster in excel using ADO

[ST]

I am using ADO to generate few reports in excel using excel as data
source.As the size of data has increased the reports have become very
slow.How can I make these reports faster?

Thanks in advance.

[Kooster]

Assuming the report is 'scanning' the rows of data to produce the report in a
sorted order, try sorting the Excel file in advance (and thereafter) to
reduce the number of scans the report writer performs. Works like an index in
a flat-file database.

P.
--
Overcome Sales Barriers
http://salesbarriers.typepad.com/


"ST" wrote:

> I am using ADO to generate few reports in excel using excel as data
> source.As the size of data has increased the reports have become very
> slow.How can I make these reports faster?
>
> Thanks in advance.
>
>