View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Konq Konq is offline
external usenet poster
 
Posts: 2
Default Excel 2007 VBA-XLL macro speed slow

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.