Forum Discussion
Excel Extremely slow when zooming to 10%
Hi Support: Over the past 6 days I have had 5 conversations (chats & calls) with over 7 hours with Microsoft Level 1 and 2 support. I have a brand new computer (P15v Gen 3 (Type 21D8 21D9) Laptop (ThinkPad) - Type 21D8) specifically purchased to process Excel files faster! I have been processing files with hex data (640x400 cells) and then converting them to decimal and finally using Conditional formatting to create a gray scale. They are raw images that I get from my micro camera. When I copy the raw data into the sheet - the sheet at times freezes (blue circle). Sometimes it works - most of the time it does not. Then I determined that when I copy even a block of the hex area over (e.g. 50x50 area) Excel freezes. Finally in desperation I created a brand new sheet with 260 columns and 300 rows with numbers from 1 to 260 horizontally and then copied to each row. When I zoom to 10% that sheet freezes. Tech support has done this: > manually uninstalling Office
> disable graphics acceleration
> disable device manager graphics
> tried creating raw file and new formula -same issue
.. and I can say multiple times! At times there is a better lag but mostly it freezes causing me to shut the sheet down. The original files work great on my son's computer and my old laptop. The files also work fine on Excel Web. So now I have a one week old computer that is useless for the task I intended to use it for. Can someone please assist me in this problem? My case number is: 1047465002 and there is lots there!
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.
