Why does my excel window lag so much when moved around the screen? no other app windows have the problem

Anonymous
2018-05-30T21:21:39+00:00

When  I have excel open, even a tiny spreadsheet, and move the window around the screen there is severe lag. The window can keep moving around the screen for a few seconds after I have stopped moving the mouse. I am running windows 10 with all updates installed and Office 365 with all updates installed.

The lag gets worse when connected to an external high res monitor.

This problem does NOT occur with any other application window which can be moved around the screen as fast as I like with no lag.

I am running Surface Pro 3, i5 8Mb Ram with all updates installed.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

109 answers

Sort by: Oldest
  1. Anonymous
    2019-07-16T01:12:00+00:00

    UPDATE...

    My laptop has integrated Intel UHD Graphics 630 as well as an NVIDIA Quadro P1000.   

    I *disabled* the integrated graphics via "Device Manager --> Display Adapters" and restarted.  When laptop came back up it only detected one monitor from my dual monitor setup, but the lag with Outlook 2016 and Excel 2016 was resolved!   Unfortunately Nvidia control panel still couldn't detect my second monitor.  (Note: I'm also using a frustrating/buggy Thunderbolt docking station from Dell that may be confusing the issue)

    Frustrated I went ahead and re-enabled integrated graphics again via "Device Manager --> Display Adapters".  My second monitor immediately became active.  Luckily the proper window drag response with Outlook/Excel persisted.

    Now I just have to pray next time I reboot...

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-07-16T02:49:51+00:00

    Hey,

    Thanks for answer!

    It doesnt help with safe mode even :(

    Whats do to next? 

    Thanks!

    Joel

    The Problem: Report Rate on your mouse is too high.  It is polling too many times before the refresh on your screen and it lags to catch up.

    The Solution: Lower the polling rate to at least 500 or lower.  After selecting 500, it fixed it for me and lowering to 250 and 125 felt the same so I stayed at 500.

    First check your polling rate

    If you are over 500Hz, then this fix is for you.

    For my Logitech G502, that means opening the software application > customize onboard profile (the moues/memory chip icon) > report rate > selecting 500 for polling rate.

    • If you don't have Logitech, try to find the report rate or polling rate or reports per second for your software and lowering it to 500 or lower
    • If you use Window's driver for your mouse, try installing the proper software for your mouse so you can change the report rate
    • If you can't do that, try downloading mouse rate adjusting program, you can find some on Tom's Hardware and simply adjust to 250 or 500 instead of 1000

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2019-07-19T16:09:24+00:00

    Same here, very annoying. but this does not happened to older version of excel such as 2010, only to the newest office suite.

    Microsoft please release an update to the current office.

    This is caused by gaming mouse, but gaming mouse is good for work too and it should not have happened.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2019-07-19T16:50:59+00:00

    The reason it does not happen in older versions is that MS has made fundamental change to the program code that writes the Excel application to Windows. This program code is integral to each program.  MS did that sort of change Word 2013. In Word 2013 people complained about a change in how Word drew unprinted boundary lines around the text. In 2010, the border was drawn as a single line around all of the text, a "page" border. In 2013 the border was drawn around each paragraph individually. MS replied that this was "as designed", 2013 had fixed a "bug" in 2010. We didn't agree that the way that 2010 worked was the bug, but it's MS's call.

    For the most part the change is transparent, except when there are unexpected interactions. In this case high polling speed mice interfere with the Window drag event. The mouse sends a message to Windows/Excel "n times per second" (the polling speed) reporting how much it has moved to adjust the location of the mouse pointer. When you are dragging, the application has to also calculate how the application window looks in the new location.  That requires a LOT more calculations than simply repainting the mouse pointer.  The gaming mice now send too many of these messages for excel to handle smoothly. This is a change to very fundamental application code. Even if the required code change is simple, it will require extensive testing to ensure the "fix" does not cause other problems. That kind of testing takes time.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2019-07-19T18:15:35+00:00

    I have never owned or used a gaming mouse. I started this thread because my office apps are almost unusable because of the lag. Excel 2013 is the worst case. Excel lags even when I have a blank spreadsheet open. I have tried reducing the number of cores used to free up draw resources for Not sure if it helps at all.

    Todd

    Was this answer helpful?

    0 comments No comments