Excel 2016 crashes with large sheets and filtering
When opening a large file and start filtering, work with that filter, use a second filter dn remove one of the filters Excel crashes
Hi all, the original issue reported in this thread was due to Win10 changes in Accessibility. The fixes for this have been released for Excel 2013, Excel 2016 and Office 365 subscribers in March.
For more information, this thread has the discussion: http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/excel-filtering-problemmatic-after-windows-10/f6f34982-d4e0-47b3-bd37-772fd51e0ff3.
Ashvini Sharma [MS]
D Nash commented
Same, this is very frustrating and has been happening to me for a number of weeks, sort it out Microsoft!
Mark Williams commented
Where can I get these updates?
My job is to filter large amounts of data and I am having the same issue It seems to freeze then the filter reappears on the screen,everytime I enter the text search it does the same think displaying a blank text box. I need to provide counts for my clients. Can anyone suggest another program other than Microsoft where I can filter my excel data?
I have been trying to do this count for the last 1 hour with the same issue. I am only working with 84,445 within my search and I do not consider this enough records for the system to fall over. Can you please help.
Still encountering issue August 2019. When will this be fixed?
Filtering tables using filter buttons or formulas causes Excel 365 in Windows 10 to become unresponsive and crashes. I could have anywhere from 10,000 to 500,000. I am using Excel while using slicers are instantaneous. Is there a fix for it?
No updates available (on latest 365) and this happens regularly. Keep it up Redmond, you're begging Open Office or Libre to harvest your users. Heck even G Sheets is becoming an alternative.
Quit adding **** like Linked In into my spreadsheets and maybe this stuff wouldn't happen. Nobody needs to share spreadsheets on Social Media. You clearly don't even use your own products.
And now it's August 2019 and the issue still happens!
It's now July 2019, still not fixed.
I am having this issue as well. I turned off auto calculation and only wanted to sort one table and my whole sheet has been locked up for 20 mins. Using Excel 2016 64bit on fully loaded developer laptop. Oh finally... it stopped processing! When will this be fixeD?
J Rapoport commented
I have several clients who are experiencing this issue as well. They try to filter a large spreadsheet and Excel goes non-responsive forcing the user to kill Excel. IN which faerie kingdom does Microsoft believe that they have resolved this issue??
Having the same problem on "large" (16k rows) sheets. The second I press filter the whole thing becomes unresponsive.
I have 2 documents with 100,000 rows and it freezes the second I press remove duplicates. How am I supposed to reduce the file size so it doesn't crash if I filter/remove duplicates?
I have just 'upgraded' and Im having this issue now....has this ever been resolved do you know? please tell me there is a fix?...its driving me nuts
Vivienne R. Goosby commented
This is still an issue. I'm working with a sheet with 16,000 rows and it freezes when I attempt to sort the columns by cell color. Please, please, please fix.
I have this problem ALL the time! It's so frustrating having to work with large spreadsheets because I know at some point I will lose my work. Don't us the option of having so many rows if the system is not going to be able to handle it! It's 2019 and this is very much still a problem!
This version of excel is the WORST. It's so unstable and crashes due to the stupidest thing. I wonder how it got past their quality control or they probably don't care anymore since they have the big bucks.
Help Microsoft! This is a problem for me too. I hate having to recreate entries since my last save....and always choosing a recovery file...this can't continue....please fix this problem!
still a HUGE problem. The fact that it freezes entirely with large data is another issue but the fact that I cannot filter for 5 unique values in a single column is ridiculous. Makes for a great explaination as to why reports are late.
Feb 2019. Spreadsheet with only 2270 rows. Freezes. Can't do anything. What the HECK?
Still an issue
Same here, this issue is not fixed.
Have all the most recent updates installed and the only way to stop this is to disable to touchscreen.