• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel & SMP?

P

peemo

Golden Member
Can Excel 2000 take advantage of dual processors? Is it really multi-threaded? I'm considering a major upgrade at work.

Thanks.
 
Yes it can, Excell 2000 On Windows 2000 Proffessional/Server/Adv Server can use both processors.

Edit: Not sure about WinMe and SMP though
 
Thanks, I'm using WIN2K. Do other Office 2000 apps use both processors?

Anyone measured the difference between Excel single CPU/dual CPU? Anyone know where I can find single vs. dual SYSMark 2000 scores?
 
Just about any windows application breaks down what its doing into a few dozen threads, its up to windows to assign a threads to a CPU, unless of course there are applications that are designed to use two CPU's, at that point you will actually notice a nice performance increase. Dual CPUs are really meant for server applications, like webservers, database servers, where there will be hundreds of new threads coming in and lots of old ones to kill. I dont really see the need for a dual CPU set up for Office 2000, unless maybe you have some very intense Excell calculations running on a Sh%*load of records.

If you want to get smooth Office 2000 work done on Win2k, this is a good setup:

800Mhz CPU or Higher (preferably 133 Mhz FSB)
Partitioned Drive, or better yet seperate drives, one for OS one for Applications.
256MB of Ram this gives Win2k room to work, 384 would be a tad better but more than that for office applications and you wont notice any improvement.
 
Thanks Train,

I had heard before that there was not much benefit to be had from dual CPUs in Ofice apps but the web guru at our company swears by it. Actually, I do have large spreadsheets with a sh8tload of data.. Right now I'm using a Dell PIII866EB on an 815 board with 256MB of RAM and this morning I halted it completely in mid recalc. I was just doing a percentrank calc on approx. 22,000 values which are part of a much larger dataset. I created by simple formula and tried to copy it down 22,000 rows and the begger just hung. Task Manager says "not responding". Unless Excel and/or Win2K can split up a job like this, I don't think a dual; machine will help much.
 
Peemo, instead of going to a dual CPU, try importing your records into Access, and doing the calculations there, I have an access DB of 47,000 records and I can add a calculated field (very hefty calculations) to it in about 3 seconds on a P3 700

I'm not sure Excell is as scalable
 
Hey Train,

I do use Access but it's not as convenient for some calculations. I'm fairly new to Access, maybe I'm missing something. Can I use any and all Excel functions in Access? Can I create graphs in Excel that grab values from Access?

As for the dual CPU, if my employer will pay for it I may try it out.

Thanks for your replies.
 
Peemo,

well, good point, if your not paying, go for it 🙂 that would be a kick ass RC5 machine.

As far as i Know, you can use every excell fucntion in Access, though some of them may be named differently. And since the rows and columds in a db environment are handled slightly different than a spreadsheet environment, you will need to word them differently in some cases, but you will get the hang of that very fast. And yes you can use Access Data as the back end for Excell graphs, no sweat.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top