Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-14-2018, 12:35 AM
coryspeth coryspeth is offline Windows 10 Office 2016
Novice
 
Join Date: Dec 2018
Posts: 2
coryspeth is on a distinguished road
Default Excel freezing large data sets

Hi,

This issue is currently only present with one of my computers so it makes me believe it is a driver issue.



I have a large excel file with a large set of data e.g. 50 000 rows. This issues happens when I start scrolling down and the data will stop loading and show a blank/grey screen. The mouse updates e.g. shows blinking typing line, cell selection etc but excel is not responsive. It feels like its working but the screen is not updating/registering changes. The only way to fix this is close (still gives the option to save etc) and reopen. Problem will occur again when i scroll up or down the lines.

I've done a fresh install of windows, reinstall of office and disabling hardware acceleration. I have a feeling its GPU drivers/memory or a resolution issue (This only happens on this computer 1440p resolution).

Here are a few links of the same issue but no solution.

HTML Code:
https://www.reddit.com/r/excel/comments/9o1jf6/documents_freezing_when_scrolling_around_sheets/
HTML Code:
https://answers.microsoft.com/en-us/msoffice/forum/all/excel-365-worksheet-is-completely-grey-after/b40364a0-c1ca-4b62-ac77-cbd236a5c87f
HTML Code:
https://answers.microsoft.com/en-us/msoffice/forum/all/cells-in-excel-2016-grey-out-when-scrolling/6c663c38-4df9-4e84-b25f-1d2f9e248b59
Thanks.
Reply With Quote
  #2  
Old 01-06-2019, 06:21 AM
radicalrom radicalrom is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2019
Posts: 9
radicalrom is on a distinguished road
Default Suggestions

Just adding my 2 cents.

Is the 1440P computer cpu slower and have less memory. 50K lines is a fair amount, but I work with 70K lines often. Unless I am trying to do many calculations and intense cpu resources, I do not have this problem and I do, it usually not lock up (might be delayed). I have had it lock up, but I realize that I had a lot of other programs running at the same time and I have closed the other programs.

To me it sounds like you have the computer optimized. One question is when this happens, what is going on in the task manager? Is the CPU, hard drive, etc. maxed? It would be interesting to see how it is killing the system.

For me, I would think that it is a memory issue, but yes drivers could be causing the issue. I have had issues with drivers causing odd things on my system (not with excel) and yes you can call me lazy, I use 2-3 different driver updater programs. Why so many? It is more of a matter making sure I have the latest driver for everything (sound, video, etc.) and I find each program to be better in certain areas on getting updates. I just use the free programs.

I know this post is a lot of questions and comments, but I wanted to give you my 2 cents.

RadicalROM
Reply With Quote
  #3  
Old 01-07-2019, 04:37 AM
coryspeth coryspeth is offline Windows 10 Office 2016
Novice
 
Join Date: Dec 2018
Posts: 2
coryspeth is on a distinguished road
Default

Hi Radical,

Thanks for the information. Unfortunately I still have not been able to pin point the cause of the issue.

The 1440p laptop is actually my better laptop with an i7 8550u 16GB ram vs my work laptop with an i5 6200u 8GB ram (which has no issues with the file).

I think its a driver optimisation issue with either the resolution or trackpad(?). It appears to only happen when I use the trackpad (two finger swipe) to scroll - even if i leave the file open for 5 minutes to 'load', the use of the trackpad makes excel non-responsive. My work around is to scroll down the sheet from top to bottom slowly by holding and dragging the side tab (I do this straight away when opening the file) - after doing this I can use the trackpad to scroll with no issues.

Its a strange one...and all my drivers are up to date
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting multiple data sets from a single Word Form into Excel Tom Saylor Word VBA 6 09-11-2016 05:22 AM
Excel not responding or Freezing RSCOMP Excel 6 06-28-2016 12:15 AM
merging data sets in excel 2013 nwiabrad Excel 9 07-24-2014 12:07 AM
Match two sets of data and display specific data lolly150 Excel 1 05-14-2012 10:33 PM
One bar chart for 3 sets of data rclloyd Excel 1 02-03-2006 09:51 AM


All times are GMT -7. The time now is 06:17 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft