How can I make reports faster in excel using ADO
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. |
How can I make reports faster in excel using ADO
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. |
All times are GMT +1. The time now is 06:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com