Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a workbook that calls several custom XLL's and has many custom VBA
procedures. In Excel 2003, the calculation speed with graphs is 10X Excel 2007. After reading the forum posts, I deleted all the graphs - still the same slow execution speed. The only other difference I saw was the "4 processors" running for multi-threading. So I disabled it. The calculation speed is much faster now in 2007, but still only about 1/3 of Excel 2003. Has anyone else seen this? I am running a Mac Pro (Bootcamp XP). Also, I noticed the calculation speed was actually FASTER (slightly) when running under Win XP, Parallels VM! Ideally it should run slower. Go figure. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Well, the multithreading is the main problem as timed tests with long runs
show Excel 2007 to be only 25% slower than 2003 with multithreading off. My advice: disable multithreading and see if your VBA code is much faster. I assume this only helps VBA code that calls dll or xll files. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Why So Slow? | Excel Discussion (Misc queries) | |||
excel 2007 slow | Excel Discussion (Misc queries) | |||
slow INSERT in excel 2007? | Excel Worksheet Functions | |||
Slow speed Excel with Centrino duo | Excel Discussion (Misc queries) | |||
Speed up and slow down, the auto-scroll. | Excel Discussion (Misc queries) |