Forum Discussion
PDV474
Aug 04, 2023Copper Contributor
365 Excel lags and jumps when scrolling.
Three page Excel document. When I scroll down a few lines it lags and then jumps down.
3 Replies
Sort By
- Detlef_LewinSilver ContributorCheck for massive amount of objects -> Selection pane.
- NikolinoDEGold Contributor
Excel lagging and jumping while scrolling can be a frustrating issue. There are several potential causes for this behavior, and here are some troubleshooting steps you can try to resolve the problem:
- Update Excel and Office: Ensure that you have the latest version of Microsoft Excel and Office 365 installed. Updates often include performance improvements and bug fixes.
- Disable Hardware Graphics Acceleration: Sometimes, hardware graphics acceleration can cause issues. To disable it, follow these steps:
- Open Excel and go to "File" > "Options."
- In the Excel Options window, select "Advanced."
- Scroll down to the "Display" section and check the box for "Disable hardware graphics acceleration."
- Click "OK" to save the settings and restart Excel.
- Check for Add-ins: Third-party add-ins can also cause performance issues. Try disabling or removing any unnecessary add-ins to see if it improves scrolling performance.
- Go to "File" > "Options."
- In the Excel Options window, select "Add-Ins."
- Check the list of add-ins and disable any that you don't need.
- Click "OK" to save the settings and restart Excel.
- Clear Clipboard: A large clipboard can slow down Excel. Clear the clipboard to free up resources by copying a small amount of data to the clipboard (e.g., a single cell) and pasting it elsewhere.
- Check File Size: Large file sizes with many complex formulas, conditional formatting, or data connections can impact performance. Try to reduce file size by removing unnecessary elements.
- Check for External Links: External links to other workbooks can cause delays. Check for and remove any unnecessary external links.
- Repair Office Installation: If the issue persists, you can try repairing your Office installation:
- Go to "Control Panel" > "Programs" > "Programs and Features."
- Find "Microsoft Office 365" in the list, right-click it, and select "Change."
- In the Office Repair dialog, select "Online Repair" and click "Repair."
- Follow the on-screen instructions to complete the repair process.
- Check for Resource Usage: Check your computer's resource usage (CPU, memory, disk) while Excel is running. If any of these resources are being heavily used, it could be a sign of performance issues.
The text and the steps was created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
- Apsis0215WareMalcombCopper Contributor
NikolinoDE - Microsoft removed 'diable HGA' for newer applications but apparently:
https://answers.microsoft.com/en-us/msoffice/forum/all/excel-disable-hardware-acceleration-setting/9568518c-0e48-4d8a-914e-352cce3dc449
Or if you have nvidia - you can accelerate individual apps as well.