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 No comments

89 answers

Sort by: Most helpful
  1. Anonymous
    2013-07-01T16:44:55+00:00

    Has there been a fix or work-around for the filtered scrolling issue with Office Mac 2011?

    I have read all the threads regarding this issue and it seems that there are a lot of things suggested to try, but nothing definitive.    My spreadsheets work perfectly when I run a Windows VM and use the same spreadsheet ... and it also works fine under a version of Open Office, so there is clearly a problem with Excel on the Mac.

    Any other ideas are appreciated.  Thanks very much.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2012-09-20T01:37:46+00:00

    One other observation:

    I ran the same Excel spreadsheet on Apache OpenOffice 3 (Calc) and I do not see any problems.  What I mean is that scrolling behavior is "normal" and there is no scrolling performance difference between filtered and unfiltered rows.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2012-09-20T00:48:11+00:00

    Adding more RAM may improve things in this case. 4gb is pretty light (never thought I would ever say that!)

    Thanks for the reply Jim.  I have not added more RAM but I have checked my activity monitory and I have nearly 2GB free when I experience this problem.  I also see people in this thread with bigger machines and 8GB RAM running into this problem with spreadsheets of similar complexity.  I also run many apps simultaneously and I don't notice any performance degradation, so I believe that I have an adequate amount of RAM.

    Also, I open the same spreadsheet on my Windows machine and I see normal scrolling and CPU usage not going above 2%, which is what I would expect.

    As I said before, my observation is CPU utilization at nearly 100% for simple scrolling.  Scrolling a basic spreadsheet is a low CPU utilization task (as common sense dictates and as evidenced on my PC), so something must be going horribly wrong during scrolling on Excel for Mac 2011.

    MS needs to resolve.

    Was this answer helpful?

    0 comments No comments
  4. Jim G 134K Reputation points MVP
    2012-09-19T17:42:47+00:00

    Adding more RAM may improve things in this case. 4gb is pretty light (never thought I would ever say that!)

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2012-09-18T19:56:52+00:00

    I have a MacBook Air, 4GB running Mountain Lion OS and Excel for Mac 2011 v14.2.3 and am having the same/similar problem reported in this column.  The problem has plagued me for over 1 year now and it is VERY frustrating since I am a long-time Excel user (Windows) and am used to good performance.  As others have stated, scrolling is very basic and poor performance can cripple usability of an otherwise powerful tool.  MS needs to put some attention on this problem and resolve it.

    To add something new, I notice that Excel CPU utilization goes to nearly 100% (ie mid to high 90's)  momentarily when scrolling.  I sometimes also see the same CPU utilization (and crippling slow response) when entering formulas, performing multiple cell selection, etc (all basic tasks).  Spreadsheets are not complicated nor are they large.  Problem is apparent when filtering is on and (typically) some columns are hidden (this also seems to make the problem worse.)  Anytime I have copied a problematic spreadsheet onto a Windows PC, the problem is not replicated and I get "normal" performance.

    Was this answer helpful?

    0 comments No comments