Skip to Content
Former Member
Nov 07, 2006 at 09:56 AM

Excel download performance issue



I have a program which downloads data to Excel using OLE methods and formats the data and creates graphs. The program and the excel file are fine. But the issue is this download takes over 20 mins. Is there some refresh / clear commands or anything which will speed this process.

One problem could be that the Excel file creation is visible when its assigning data to the cells and formatting.

Any help is welcome