Forum Discussion
Excel Extremely slow when zooming to 10%
AndyBasa Please be aware that you are not addressing an MS support organisation. This is a forum where users help each other with all sorts of Excel related issues. Some of the contributors are MS employees, but most are not and we do not have access to your case history.
Perhaps you can upload the 50x50 file or share a link to Onedrive or a similar file sharing service. Then, you'll reach many volunteers out here that can have a look at the file and run it on a great number of different configurations, helping to pin-point why that file (sometimes) creates problems.
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 systemOpening 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.
AndyBasa Interesting file. Opened it and it was already zoomed out to 10%. Could zoom in and back out without trouble. I'm using a fairly new 32GB laptop and Excel 365. Tried copying/pasting parts to other sheets. No problem.
