scrolling speed excel with filters

Anonymous
2011-11-03T04:06:53+00:00

Scrolling is terribly slow if I have filters active.

I have a 40,000 row sheet, and it scrolls normally when no filters are active.

If i have a filter that excludes most of the items except for 100 or so, the scrolling is unbearable. It's like its scrolling through the hidden rows or something to that effect.

I have updated to the latest office patch and i have a 2010 core i7 MBP with an SSD and 8GB of ram running Lion.

This is basic basic stuff, it's incomprehensible that this would be an issue.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

89 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-02-11T23:38:03+00:00

    I've done just that and got the following response.  Looks like a known issue.  None of the suggested work arounds work bar refractoring but not always practical.  If this issue is known, can I have an update on when this will be fixed?  It's a crippling bug.

    From XinXin:

    Thanks a lot for sending me your file. I looked at your file – yes, scrolling is not smooth on this workbook. There is a known issue in XL2011 – the more rows/data you filter out, the more sluggish you will observe during scrolling. There are a couple of ways to work around the issue:

    1.       Use table instead of normal range – I resaved your file (attached) in a table.

    2.       Use binary file format (such as xlsb, xls, rather than xlsx).

    3.       Try refactor/restructure the file, so that you don’t have a huge data table.

    Was this answer helpful?

    0 comments
  2. Jim G 134K Reputation points MVP
    2012-02-11T22:14:33+00:00

    As was mentioned, XinXIn is accepting submissions of workbooks to analyze. If you can offer your workbook for analysis, then perhaps the problem can be solved sooner, rather than later.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-02-11T16:18:16+00:00

    I know of no MAC / OS combination that doesn't exhibit this problem. Snow Leopard/Lion, MacBook Airs, Pros, Minis, etc. Not only is the scrolling useless when in filter mode, but I can't imagine who thought the idea of real-time filtering would be a good one. It makes no sense whatsoever... at the very least it should be a setting you enable/disable for those crazy enough to want it. 

    Got spreadsheet with 10000 rows... got 25 categories in one column. Would like to enable 12 o those.... here we go

    Filter - click on category 1.... UI freezes (ever heard of non-blocking UI?).... wait.... wait..... wait... it is probably not stuck, right?.... wait.... wait.... maybe I didn't click it... try again.... wait... wait... oh sh#&... I did... and now it is cleared again... start over... repeat 12 more times.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2012-01-27T06:31:02+00:00

    Hi Jim,

    Seems even stranger now that's this is happening on some macs and not others.

    Will be good to keep us posted.

    Was this answer helpful?

    0 comments
  5. Jim G 134K Reputation points MVP
    2012-01-27T02:41:53+00:00

    Hi Dan,

    Not every Mac user is experiencing the scrolling problem. XinXin is in a position to figure out why it is happening to some users, but not the majority of them. I tried to reproduce the problem, but scrolling works fine on my not particularly powerful Macs.

    Was this answer helpful?

    0 comments