Excel 2007 VBA-XLL macro speed slow

**Konq** · April 4th 07, 09:12 PM 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.

**Konq** · April 18th 07, 02:18 AM 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 Why So Slow?	Chaplain Doug	Excel Discussion (Misc queries)	10	April 17th 07 11:42 AM
excel 2007 slow	jojobold	Excel Discussion (Misc queries)	4	February 27th 07 12:15 PM
slow INSERT in excel 2007?	Loren Meissner	Excel Worksheet Functions	1	January 31st 07 05:51 PM
Slow speed Excel with Centrino duo	jmb.	Excel Discussion (Misc queries)	3	September 11th 06 12:35 PM
Speed up and slow down, the auto-scroll.	Jack Tripper	Excel Discussion (Misc queries)	0	September 11th 05 03:54 PM