>> System Experts: Help me identify a bottleneck issue

[tapsemi]

I am doing some programming in excel, such that each cell is calling some specific data from an internet based server. There are say 400x20=8000 cells querying some sort of data. I created a refresh button such that when I click that button, the excel worksheet will query the data and update the results.

Now my problem is that this process takes over 15 minutes. I have a 2year old PC with a dual core intel cpu and 2G ram connected with a 3Mbps DSL line. During the Excel data update time, I check Windows task manager->Processes and I see something as Excel.exe 50 and System Idle Process 48.

Hence I am hypothesizing that the delay is not my System. However the internet server is a highly commercial system and to a 1st degree I will not suspect that it is really slow.

Puzzle: How do I findout the root cause of my bottleneck? Please advise! :'(

 

[theevilsharpie]

A single-threaded process on a dual-core system can, at most, consume 50% of your CPU resources. According to the information you posted, your bottleneck appears to be in Excel somewhere.

 

[tapsemi]

A single-threaded process on a dual-core system can, at most, consume 50% of your CPU resources.

If this is true, then can I say I am CPU power/speed limited?

According to the information you posted, your bottleneck appears to be in Excel somewhere.

How to measure / check this?