Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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

6 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    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.

    thanks
    ash

    Ashvini Sharma [MS]
    Excel

    75 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        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!

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • TimNut commented  ·   ·  Flag as inappropriate

        Feb 2019. Spreadsheet with only 2270 rows. Freezes. Can't do anything. What the HECK?

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • Darrell G commented  ·   ·  Flag as inappropriate

        As a number of others have reported, this has NOT been fixed. Extremely frustrating. Needs to be fixed. I'm having the same problem adding columns and even changing the formula for a single cell in some sheets. Turning off automatic calculations DOES NOT fix the issue, so it shouldn't be an issue of daisy chained dependant calculations. UGH!

      • Anonymous commented  ·   ·  Flag as inappropriate

        Have been encountering this issue for some time now. Very frustrating. Excel display becomes unresponsive after removing a filter. Still able to save and close, but happens every few minutes.

      • Rick K commented  ·   ·  Flag as inappropriate

        This is why Microsoft shouldn't call themselves "Enterprise". They are not ready for handling files bigger than a letter to grandma.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Windows 10 make my excel 2013 & 2016 slow compare to windows 7.

        If necessary to calculate a fix time, there will have huge different when deal with large excel files, even i using Excel 64 bits.

        Any alternative way can turn off any option / features to lighten Excel work under Windows 10?

      • Anonymous commented  ·   ·  Flag as inappropriate

        Its not just on large files, we are having the issue on simple spreadheets with no more than 100 lines and no formulas, filtering makes excel unresponsive, although suprisingly does allow you to save and close all workbooks, whcih you have to do then re-open.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Filtering tables using filter buttons caused Excel to become unresponsive while using slicers are instantaneous. A 1MB with tables that contain formula's takes upto 5 mins to respond after adding row's or columns and the table is only 10 rows by 4 columns. If it isn't broken don't fix it. Come on Microsoft sort this out!!! Excel is bread and butter for People in Finance.

      • ben commented  ·   ·  Flag as inappropriate

        This has not been solved as I still have the problem with some users in our company. I will try to repair the office installation and see if it helps.

      • Jeff M commented  ·   ·  Flag as inappropriate

        It's bad code.

        Watch how a large filtering operation only uses one core of your CPU vs. recalculation uses all of them.

        They've neutered the code but still can't solve it.

        Bigtime FAIL.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Several employees in our organisation have reported this issue also. Is it still related to a Microsoft update issue?

      • Anonymous commented  ·   ·  Flag as inappropriate

        I'm having this issue quite frequently as well. It's nailed me twice now in two days. I try to save pretty frequently, but this has still cost me more than an hour in the last two days. Is there any discussion of a fix for this?

      ← Previous 1 3 4

      Feedback and Knowledge Base