A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
For me, it only seems to be slow on files that have macros.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
This problem started yesterday.
I installed the optional feature update and then the .NET update yesterday, and the problem appeared resolved, but now again today the problem is back?
When ever I change a table filter, Excel freezes for like at least 30 seconds. It's not specific to a particular spreadsheet, it happens on all spreadsheets.
The only other change I've made is change my mouse pointer color and cursor size?
Regards,
AjN3806
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
For me, it only seems to be slow on files that have macros.
Yes that is what I find as well
Also generally works ok except when closing the file
It now saves quickly - but if select close (either in menu or top right 'X' button then it more or less hangs
I note in task view that the amount of memory being used build rapidly as well
So I can use it fine now - so long as I don't close any workbooks.
I do that at the end of the session - save each workbook then press cntrl-alt-del - select task view and close excel
I was getting extremely slow screen updates. When I move my mouse the buttons and other UI elements would only highlight about once per second. Every time I move the mouse and click I had to wait about five seconds for the display to catch up.
For me, selecting Optimize for compatibility did not solve the problem. But because it was a display update issue I tried disabling the GPU and that solved it!
File > Options > Advanced > Display > Disable hardware graphics acceleration.
Restarting Excel afterward was not required. It immediately started working right.
This is in Office 2016, but I believe the setting is the same in Office 365.
My GPU is an Intel UHD Graphics in a new Dell XPS 17 running Windows 11. It's a very high-end machine to be giving such a crappy experience.
Oh my god thank you so much for this.
I've been monitoring this thread for 2 months now and I began to increasingly use Excel on Onedrive and through Remotedesktop of my Uni because this was really hindering my work with Excel.
It was just like you described, laggy graphics, and nothing on this thread before this had resolved it.
Your solution resolved it immediately, no restart required. Mine's a high end machine too, similar config as yours and I had been almost convinced to switch to a Mac next time because of this experience.
Very much appreciated; works extremely well so far.