Excel Macro using only 1 cpu and is painfull slow

[Uberwilhelm]

Howdy all.

I have an excel 2007 spreadsheet with a macro that imports data from an access database. Normally when it runs you see "using 4 cpus" on the bottom but lately it has been going painfully slow and only using a single cpu core. What normally took 30 seconds or so to run now take 10 minutes and I want to pull my hair out. Any suggestions? Many thanks.

[MarvinP]

Hi Uberwilhelm and welcome to the forum,

To make VBA run faster there is the best read:
http://www.cpearson.com/excel/optimize.htm

Hope this helps.

[Uberwilhelm]

Thanks for the reply Marvin.

I went through the suggestions but I don't quite understand how those tips would effect the CPU usage. Oddly enough, the macro just decided to start using all 4 CPUs again this morning. Makes no sense.

[JapanDave]

I could be a problem with your code. Maybe post a workbook and see if the code can be made more efficient?

[JosephP]

vba is single threaded and will only ever use 1 cpu but there is an option to turn multithreaded calculation on or off. mtc will use multiple cores when it can.