Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-14-2018, 12:35 AM
coryspeth coryspeth is offline Excel freezing large data sets Windows 10 Excel freezing large data sets Office 2016
Novice
Excel freezing large data sets
 
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
 



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
Excel freezing large data sets One bar chart for 3 sets of data rclloyd Excel 1 02-03-2006 09:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft