Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excell 2007 performance issue
Hi all,
We are using Excel 2007 for reporting in our organization. Basically there is a Java web application which instantiates Excel with an XLAM. This XLAM opens a Report Template(an .xls, .xlsm file). The Template has a data sheet where data is pasted on number of ranges and the Report sheet which shows the final report based on the data from the DataSheet. The ReportSheet contains formulas to show the final output. It could also contain Charts/Graphs. The data pasted on ranges is fetched from SQL server. And finally when Macro is run the Template is saved as a Final Report somewhere on the Report Server. All these operation occurs on the template saved locally. The Excel runs in the background in all this process. There could be multiple instances of Excel running on the same box. The instances run under separate WindowStations. What I have noticed is that Opening a Workbook, Saving As and Closing it takes approximately 5-15 sec, 25-60 sec, and 2-5 sec respectively. Also XLAM invokes a Macro (from Template) which consists of nothing but a loop just to simulate something, takes 25+ sec. whereas it should be taking nothing more than 11-12 sec. Please let me know if there is any way to improve the performance or find out the root cause of the issue. Any help appreciated. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Performance Issue | Excel Discussion (Misc queries) | |||
Excell 2007 / 2003 Compatability Issue | Excel Worksheet Functions | |||
Performance issue | Excel Programming | |||
Excel Performance issue | Excel Discussion (Misc queries) | |||
Iteration performance issue | Excel Programming |