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.