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