Is an anti-virus program running? It could be checking the Excel file every time it gets updated.
FYI: Excel running on the server is not supported by Microsoft and not recommended.
>Hi all,
>I have a program that export date to excel, I use OLE automation. It does a select and a sort then open's excel and starts to populat the sheet. It's simple and just for 1 customer. I had to add a column to the report and when testing I noticed that it ran very slowely, 1 row per second (no calculation or formatting done when running), but I put this down to the server. I then clicked on the scroll bar and the program sped up, doing 4-5 rows per second. I am able to reproduce the behaviour, and would love to be able to have that speed in normal operation, but no idea why this is happening or how to achieve it in the normal running of the program, any idea?
>~M
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer