Forum Discussion
Excel Extremely slow when zooming to 10%
Processor Intel(R) Core(TM) i5-7260U CPU @ 2.20GHz 2.21 GHz
16,0 GB RAM
64 bit system
Opening the workbook took a long time on my computer.
I removed the conditional formatting and set the calculation to manual.
Then I set the zoom at 100% and start decreasing by 10% steps.
Every step was reacting slower than the previous step.
Hi Detlef & Riny: Now I think you are seeing my dilemma. On some computers it is fine, on others it is a problem. I don't think it has to do with conditional formatting, as I was able to reproduce the situation with just the data portion of the file and zooming in and out and also copy blocks of it.
I currently have a Windows 11- Build 22621, Office 365 Excel build 2211: on a Intel I7-10750H @ 2.6GHz, with 16GB Memory and NVIDA graphics card. On this computer it completely bogs it down especially at the 10% level. I have updated all drivers and software and nothing seems to change.
Hopefully someone can figure out what is happening between Excel and the computer to cause this to happen on some configurations.
Thank you for trying it and your feedback.
- Hi Community: Is there anyone that can suggest what can be going wrong with Excel working with this file at the 10% zoom level? Are there some settings or incompatibility between Excel and the computer that can be adjusted? Thank you.
@Detlef Lewin @Riny_van_Eekelen Hi community: I was able to find the source of this issue that I am experiencing. It is caused by the Windows 11 22H2 update! My son purchased a new computer a few days ago with Excel installed on it out of the box. We tested the example excel sheet on it and the example flew at record speed. Well some 1 hour later when he applied the Windows update above, Excel exhibited the exact same issue! We did not update Office - so it was only Windows and the Laptop drivers. When he rolled back the Windows update and retested Excel - the program worked great. I confirmed this with Microsoft Tech support supervisor who also did this on my computer. I hope that Microsoft figures out this bug in their upgrade and corrects it soon. I have suspended updates on my Laptop until I absolutely have to or Microsoft somehow indicates they found this bug.
AndyBasa Hi! Could you give us an update to your 22H2 error?
Have you been staying on that feature update for all this time? I am having issues with my (older) PC as well and am unsure of rolling back all that way.
I will be updating the PC next year (intel 15 series) for a fighting chance at these unusable excel spreadsheets.
