Excel takes up 100% CPU

[langlang98]

I have a macro that runs for approximately 90 Sales Rep files. The macro itself runs fairly quick but I have noticed that I am unable to do anything while the macro is running due to Excel Automatic Calculate will use 100% of the CPU Usage throughout the macro. I have to calculate the spreadsheets due to needing to use a filter on values so whether I Manually Calculate or Automatic Calculate will not change the result of the "Calculations" taking 100% of the CPU Usage. I was wondering if there is a way to set Excel to only use 50% of the CPU Usage. I am running Excel 2007 on a 1.6Ghz Pentium Core Duo. Also, I am slotted to get a new computer in the next couple weeks that will be Quad Core but figure I will still have the same issue except that it will calculate faster. Is there a way to run the macro in the background where it will use fewer resources or set Excel not to use 100% resources.
Thanks,
Jim

 

[Derek Brown]

Have a look in Excel Options | Advanced | Formulas
where the multi-threading option can be set/unset.