RE: Excel Limitations??

From: Peo Sjoblom (PeoSjoblom_at_discussions.microsoft.com)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 09:39:01 -0800

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 spread*** 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?
>

Loading