>Hi,
>I have a program that creates and formats an excel spreadsheet (25 rows - 19 columns). The trouble is on my 733MHz (256K ram windows 2000) it takes less that 5 seconds after getting the data. But on a clients 400MHz (64K ram NT 4.0 SP4)it takes over a minute. Task manager on the clients reports that the CPU = 100% but I don't see any swaping. Anyone have any thoughts regarding how to increase performance for the client.
>
>TIA
>John

John,
I don't think the formatting is the real bottleneck there (might be but ?). Though your local timing is extra slow ( 5 secs for 25*19 ??? ) I wonder what kind of formatting it's. Also I get your RAM as 256Mb not 256K. Even pentiums shouldn't be slow that much. I export data of 10000 recs to Excel, create 4 pivots and format their table, generate 5 graphs and all take less than 5 secs with Athlon 650-196Mb RAM Win2K.
In your client all including excel is invoked from a network server ? IOW how much does opening Excel alone take ?

However there are things making it slow like :
-Doing formatting cell by cell when it could be applied to a range
-Making Excel visible before formatting...
Cetin