Excel 2016 frequently slow and loading CPU without obvious reason
I am working with excel a lot. I wonder why sometimes it starts eating 50+% of my CPU slowing everything down even when no calculation of formulas is happening and I didn't start any action! Funny thing is that usually this stops when I close one of the opened workbooks and it absolutely doesn't matter which one. Even some which I opened 2 hours ago and didn't touch since - if I close it then suddenly Excel stops being crazy and is usable again!
The almost guaranteed way to make Excel super slow and overload CPU is a simple pressing of Ctrl+C. Things don't get calm until I paste it somewhere or press Esc which is quite often very hard when everything reacts so slow at that time. It happens to me and my colleague as well with various workbooks and it does not seem to be related to any specific file as we work with many and create many. Any ideas?
microsoft-excel performance cpu-usage
add a comment |
I am working with excel a lot. I wonder why sometimes it starts eating 50+% of my CPU slowing everything down even when no calculation of formulas is happening and I didn't start any action! Funny thing is that usually this stops when I close one of the opened workbooks and it absolutely doesn't matter which one. Even some which I opened 2 hours ago and didn't touch since - if I close it then suddenly Excel stops being crazy and is usable again!
The almost guaranteed way to make Excel super slow and overload CPU is a simple pressing of Ctrl+C. Things don't get calm until I paste it somewhere or press Esc which is quite often very hard when everything reacts so slow at that time. It happens to me and my colleague as well with various workbooks and it does not seem to be related to any specific file as we work with many and create many. Any ideas?
microsoft-excel performance cpu-usage
So I have spent a long time reading some forum threads with various suggestions and today after few hours of working it looks like fixed. I have checked "disable hardware graphics acceleration" in options / advanced / display. I will confirm after few days and make this an answer. However my colleague didn't confirm this helps in his case ...
– Vitas
Feb 7 at 11:47
add a comment |
I am working with excel a lot. I wonder why sometimes it starts eating 50+% of my CPU slowing everything down even when no calculation of formulas is happening and I didn't start any action! Funny thing is that usually this stops when I close one of the opened workbooks and it absolutely doesn't matter which one. Even some which I opened 2 hours ago and didn't touch since - if I close it then suddenly Excel stops being crazy and is usable again!
The almost guaranteed way to make Excel super slow and overload CPU is a simple pressing of Ctrl+C. Things don't get calm until I paste it somewhere or press Esc which is quite often very hard when everything reacts so slow at that time. It happens to me and my colleague as well with various workbooks and it does not seem to be related to any specific file as we work with many and create many. Any ideas?
microsoft-excel performance cpu-usage
I am working with excel a lot. I wonder why sometimes it starts eating 50+% of my CPU slowing everything down even when no calculation of formulas is happening and I didn't start any action! Funny thing is that usually this stops when I close one of the opened workbooks and it absolutely doesn't matter which one. Even some which I opened 2 hours ago and didn't touch since - if I close it then suddenly Excel stops being crazy and is usable again!
The almost guaranteed way to make Excel super slow and overload CPU is a simple pressing of Ctrl+C. Things don't get calm until I paste it somewhere or press Esc which is quite often very hard when everything reacts so slow at that time. It happens to me and my colleague as well with various workbooks and it does not seem to be related to any specific file as we work with many and create many. Any ideas?
microsoft-excel performance cpu-usage
microsoft-excel performance cpu-usage
asked Feb 6 at 16:31
VitasVitas
568516
568516
So I have spent a long time reading some forum threads with various suggestions and today after few hours of working it looks like fixed. I have checked "disable hardware graphics acceleration" in options / advanced / display. I will confirm after few days and make this an answer. However my colleague didn't confirm this helps in his case ...
– Vitas
Feb 7 at 11:47
add a comment |
So I have spent a long time reading some forum threads with various suggestions and today after few hours of working it looks like fixed. I have checked "disable hardware graphics acceleration" in options / advanced / display. I will confirm after few days and make this an answer. However my colleague didn't confirm this helps in his case ...
– Vitas
Feb 7 at 11:47
So I have spent a long time reading some forum threads with various suggestions and today after few hours of working it looks like fixed. I have checked "disable hardware graphics acceleration" in options / advanced / display. I will confirm after few days and make this an answer. However my colleague didn't confirm this helps in his case ...
– Vitas
Feb 7 at 11:47
So I have spent a long time reading some forum threads with various suggestions and today after few hours of working it looks like fixed. I have checked "disable hardware graphics acceleration" in options / advanced / display. I will confirm after few days and make this an answer. However my colleague didn't confirm this helps in his case ...
– Vitas
Feb 7 at 11:47
add a comment |
1 Answer
1
active
oldest
votes
Go to options / advanced / display - and check "disable hardware graphics acceleration"
This helps on my system Thinkpad T460: with core i5-6300U. However this is NOT a universal solution as my colleague with T470 core i5-7300U tried it and it does not have any effect :-)
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1402753%2fexcel-2016-frequently-slow-and-loading-cpu-without-obvious-reason%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Go to options / advanced / display - and check "disable hardware graphics acceleration"
This helps on my system Thinkpad T460: with core i5-6300U. However this is NOT a universal solution as my colleague with T470 core i5-7300U tried it and it does not have any effect :-)
add a comment |
Go to options / advanced / display - and check "disable hardware graphics acceleration"
This helps on my system Thinkpad T460: with core i5-6300U. However this is NOT a universal solution as my colleague with T470 core i5-7300U tried it and it does not have any effect :-)
add a comment |
Go to options / advanced / display - and check "disable hardware graphics acceleration"
This helps on my system Thinkpad T460: with core i5-6300U. However this is NOT a universal solution as my colleague with T470 core i5-7300U tried it and it does not have any effect :-)
Go to options / advanced / display - and check "disable hardware graphics acceleration"
This helps on my system Thinkpad T460: with core i5-6300U. However this is NOT a universal solution as my colleague with T470 core i5-7300U tried it and it does not have any effect :-)
answered Feb 12 at 16:01
VitasVitas
568516
568516
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1402753%2fexcel-2016-frequently-slow-and-loading-cpu-without-obvious-reason%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
So I have spent a long time reading some forum threads with various suggestions and today after few hours of working it looks like fixed. I have checked "disable hardware graphics acceleration" in options / advanced / display. I will confirm after few days and make this an answer. However my colleague didn't confirm this helps in his case ...
– Vitas
Feb 7 at 11:47