Excel 2016 frequently slow and loading CPU without obvious reason












1















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?










share|improve this question























  • 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


















1















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?










share|improve this question























  • 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
















1












1








1








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?










share|improve this question














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






share|improve this question













share|improve this question











share|improve this question




share|improve this question










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





















  • 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












1 Answer
1






active

oldest

votes


















0














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 :-)






share|improve this answer























    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
    });


    }
    });














    draft saved

    draft discarded


















    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









    0














    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 :-)






    share|improve this answer




























      0














      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 :-)






      share|improve this answer


























        0












        0








        0







        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 :-)






        share|improve this answer













        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 :-)







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Feb 12 at 16:01









        VitasVitas

        568516




        568516






























            draft saved

            draft discarded




















































            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.




            draft saved


            draft discarded














            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





















































            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







            Popular posts from this blog

            Probability when a professor distributes a quiz and homework assignment to a class of n students.

            Aardman Animations

            Are they similar matrix