Forum Discussion
Excel Extremely slow when zooming to 10%
Hi Riny: I appreciate the guidance. I have now created a simple version of my spreadsheet and I called it Exceltest. The sheet is comprised of data 640 columns x 400 rows (top 1/2 of sheet) that was converted from a RAW file originally in hex from a camera. The lower portion, I created a conditional formatting to convert that to a gray scale and where I can see the image I am working with. My challenges occur at the 10% zoom level. When I copy a block of the top data for example and paste it to another location (just as a test) - say 100x100 cells - Excel bogs down on a number of computers and virtually halts. On some others it works flawlessly. Normally I copy the entire 640x400 rows from another excel sheet over the existing one as I keep processing and working with the image. My old computer (Inspiron 5555 AMD A10-8700P Radeon R6, 10 Compute Cores 4C+6G, 1800 Mhz, 2 Core(s), 4 Logical Processor(s)) it works but slowly. On my more powerful Intel with NVDIA it bogs down and I am forced to shut down Excel as it does not respond. Task manager shows lots of CPU, Memory and Graphic resources (all below 40%) when I run Excel on both computers. There must be something unique about Excel and the computer that bogs down this spreadsheet that I would appreciate a solution or suggestion. I enclose the spreadsheet.
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.
- AndyBasaDec 18, 2022Copper Contributor
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.
- AndyBasaDec 21, 2022Copper ContributorHi 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.
- AndyBasaDec 29, 2022Copper Contributor
@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.