Determine Max cores and set Excel process to use 1 less than max

**Kramxel** · 04-14-2015, 05:00 AM

Hi All,

I've built a bit of a monster excel application and really need to speed it up for some of our users who's desktops are both varied and in some cases a little on the low side in terms of CPU and RAM power.

I have used the code below to increase the priority of the application to HIGH which enables the users to get the data they require far far quicker and then hop out.

However this makes the system entirely unable for the few minutes the calculations take - is there a way to set to determine the number of cores the user has available and set the affinity to 1 less than max? we have a variety of dual, quad core and a couple of 8 core units so setting an arbitrary figure isn't an option.

(we're doing this manually to get a balance of both but it'd be nice to automate this step also)

Thank you.

CPU PRIORITY CODE:

Please Login or Register  to view this content.

**adhawan06** · 04-14-2015, 05:25 AM

Hi Kramxel,

Your post does not comply with Rule 5 & 8 of our Forum RULES.

Forum Rules
Please read and adhere to these simple rules!

5. Don't duplicate threads. If you have posted the question in one forum, do not post it again in another forum. You are duplicating efforts. If you feel the thread is in the wrong forum and needs to be moved to another forum, PM a mod / admin to do it for you.

8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.

Cross Post link - http://www.excelforum.com/excel-prog...-than-max.html

**Kramxel** · 04-14-2015, 05:56 AM

Apologies I only his submit once but there was a scripting error in my browser which I refreshed and I assume caused this to be posted twice -- can you delete the duplicate please?

Moderator Edit: Other thread (duplicate) has been closed.