+ Reply to Thread
Results 1 to 10 of 10

Slow, Lagging and Non Responsive

  1. #1
    Registered User
    Join Date
    10-26-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    51

    Slow, Lagging and Non Responsive

    I am using Office 365 and it is almost impossible to use Excel. For whatever reason, I can open excel and use it for a few minutes and then it starts becoming slow, lagging and non-responsive. It typically take 3 to 5 seconds between each move. It seems like a memory issue, but this does not happen in any other program. I have 32 gig of ram so it should not be an issue.

    I removed and reinstalled the program, but is still has not resolved the issue. This happened to me last year and we updated the video driver and it seemed to help, but after a recent windows and Office 365 update it seem to come back with a fury.

    Can anyone help me? I need this worked out ASAP since this is one of my primary programs that I use to do business.

    Lonnie

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    43,311

    Re: Slow, Lagging and Non Responsive

    Are you working on locally stored files (on your HDD) or from the cloud?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think some-1 helped you

    Regards
    Ford

  3. #3
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - Office 365
    Posts
    7,905

    Re: Slow, Lagging and Non Responsive

    You might also consider reviewing 'Settings'. I remember similar issues when upgrading to 2013. I don't recall all the settings but 'Disable hardware graphics acceleration' made a difference.

    At that time there were also some system settings (Win8) that may not be relevant now ... I have no idea how to access them in Win10 if they are.
    Dave

  4. #4
    Registered User
    Join Date
    10-26-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Slow, Lagging and Non Responsive

    For our server which is not on the Cloud

  5. #5
    Registered User
    Join Date
    10-26-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Slow, Lagging and Non Responsive

    I did disable the hardware graphics acceleration prior to this post rand it did nothing.

  6. #6
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - Office 365
    Posts
    7,905

    Re: Slow, Lagging and Non Responsive

    A search on the net reveals this is a very common problem.
    This search string got a lot of hits. The remedies are varied. "excel slow down after upgrade 365"

    This site recommends starting in Clean Boot Mode. A link is provided for how to do this and locate/remove any problem startup applications running behind the scene. It appears to be tedious and time consuming.

    https://answers.microsoft.com/en-us/...0-2a7c65894271

    This one states that Hey Cortana is the culprit.

    https://answers.microsoft.com/en-us/...1-971668096e67

    This one states Dell Realtek audio drivers are the problem.

    http://www.brucebnews.com/2017/07/a-...e-opening-bug/


    That is just a small sampling. So prepare for a "seige".

    I'll be following this thread closely. I'm about to upgrade 365 this afternoon. So thanks for posting.

  7. #7
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    2013, Office 365 ProPlus
    Posts
    2,574

    Re: Slow, Lagging and Non Responsive

    Few things I did when I moved from 2010 to Office 365.

    1. Did full clean install (cleaned registry values as well as all app folders)

    2. Turned off Hardware graphic acceleration

    3. Turned off all unnecessary animations in Control Panel -> Ease of Access -> Turn off all unnecessary animations (when possible)

    4. Enabled multi-threaded calculation (I have 2 core with hyper threading, so I set it to 4).

    5. Also turned on multi-threaded processing under Options -> Advanced -> General

    And lastly, since I deal with large data sets quite often and use PowerQuery and PowerPivot, I've opted to install 64 bit version.
    FYI - To take advantage of 32Gb ram you'll want 64 bit version. 32 bit install will have limit of 4Gb ram usage for Excel instance.

    Have a read of...
    https://support.office.com/en-us/art...e-6c6f49b8d261

    Haven't had issue with slow-down, after above.
    Last edited by CK76; 06-15-2018 at 04:22 PM.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  8. #8
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - Office 365
    Posts
    7,905

    Re: Slow, Lagging and Non Responsive

    @ CK76,

    Thanks for that. I couldn't recall system settings or Option steps 4-5.

  9. #9
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    2013, Office 365 ProPlus
    Posts
    2,574

    Re: Slow, Lagging and Non Responsive

    Welcome and thanks for the rep

  10. #10
    Registered User
    Join Date
    10-26-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Slow, Lagging and Non Responsive

    I have tried everything and am waiting to see if the issues are still there. I will let you know.

    Thanks for your help.

    Lonnie

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1