Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Limitations??
Hi,
I'm currently running Excel 2002 on a XP Pro system with a Pentium 4 (dual CPU) 3.20 GHz with 2.00 GB of RAM. I have a large spreadsheet which evaluates live stock quotations. I'm currently receiving about 250,000 quotes via RTD links. When I attempted to view more data (up to 300,000) I started to notice an increased slow down in performance. Here are some of my stats via Task manager: avg 50-65% CPU PF Usage: 644 MB Totals Handles: 15407 Threads: 540 Processes: 44 Commit Charge Total: 659320 Limit: 6133412 Peak: 939716 Physical Memory (K) Total: 2095780 Available: 1280500 System Cache: 462088 Kernel Memory (K) Total: 97096 Paged: 58400 NonPaged: 38726 Under processes Excel. EXE takes up about 95% of the CPU and about 340,000K of Memory usage. Questions: 1) Does Excel limit the number of RTD links one can have? 2) Can you notice anything in the stats which can pinpoint what is causing the slowdown? 3) Based on the above question, will upgrading my CPU or adding more memory improve my performance? 4) Any other suggestions which might impove my performance? (speed) thanks, PS. Should I ask these questions in another section of this newsgroup? |
#2
|
|||
|
|||
This might be of some interest
http://www.decisionmodels.com/calcsecrets.htm I doubt that upgrading the hardware on your PC will make any difference Regards, Peo Sjoblom "Mike" wrote: Hi, I'm currently running Excel 2002 on a XP Pro system with a Pentium 4 (dual CPU) 3.20 GHz with 2.00 GB of RAM. I have a large spreadsheet which evaluates live stock quotations. I'm currently receiving about 250,000 quotes via RTD links. When I attempted to view more data (up to 300,000) I started to notice an increased slow down in performance. Here are some of my stats via Task manager: avg 50-65% CPU PF Usage: 644 MB Totals Handles: 15407 Threads: 540 Processes: 44 Commit Charge Total: 659320 Limit: 6133412 Peak: 939716 Physical Memory (K) Total: 2095780 Available: 1280500 System Cache: 462088 Kernel Memory (K) Total: 97096 Paged: 58400 NonPaged: 38726 Under processes Excel. EXE takes up about 95% of the CPU and about 340,000K of Memory usage. Questions: 1) Does Excel limit the number of RTD links one can have? 2) Can you notice anything in the stats which can pinpoint what is causing the slowdown? 3) Based on the above question, will upgrading my CPU or adding more memory improve my performance? 4) Any other suggestions which might impove my performance? (speed) thanks, PS. Should I ask these questions in another section of this newsgroup? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Excel Autofilter - limitations? | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) |