SMT question (I think)

[Spike]

I'm using BA with Excel 2003 (much faster than 2007) and it's imporant to me that my sheets execute as quickly as possible. My question is whether BA and Excel 2003 have SMT- enabling them to take full advantage of multicore processing, or whether I'm wasting my money on multicore servers and would be better off with more servers at a lower spec.

Does anyone know what the optimum setup is for running several sheets simultaneously at high refresh rates without incurring ridiculous IT bills?

[osknows]

Microsoft Excel 2003 and below is not designed to be a multiprocessor-aware program - http://support.microsoft.com/kb/265361

When you say Excel 2007 runs slower; I think there have been problems with this (think Vista vs W7). Some people have reported improvements re-writing all code and links in 2007 instead of just opening a workbook created in an earlier Excel version. The next version of Excel is supposed to fix this
http://blogs.msdn.com/excel/archive/200 ... -2010.aspx

Just a thought...Have you tried running mutliple workbooks instead of mutliple sheets and let your OS run these on seperate threads?

My personal opinion is that it's not worth paying the extra money to speedup your setup which could all be undone with a slow internet connection, slowdown of the site you're accessing and even the software itself.

I use the entry level Pentium I7 at home and this is more than enough for anything I have ever needed.

[osknows]

I use the entry level Pentium I7 at home and this is more than enough for anything I have ever needed.

I meant Core I7