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. Jim G 134K Reputation points MVP
    2012-05-03T02:35:43+00:00

    Dadavery - an update to Office has been released since this issue was first reported. Please update to Excel 14.2.1 as shown in the Excel menu > About Excel. To get the update use Excel Help menu and choose Check for Updates.

    After installing the updates and restarting your Mac, please try again and reply so that we know whether or not the problem was fixed by this update.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-05-02T05:09:51+00:00

    Same issue here. even purchased a new macbook only to have the same issue on the new "fresh" software and hardware.

    Very disappointed...

    Please fix this Microsoft...

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-02-23T21:30:08+00:00

    There are various reasons that scrolling is slow on Excel for Mac 2011. Please first try a few troubleshooting steps:

     

    1. Make sure both MacOS and Mac Office are patched with the latest updates.
    2. Run "disk utility" (a system utility) to repair the disk permission
    3. Run "font book"  (a system utility) to resolve duplicated fonts
    4. With all Office applications shut down,

        a. Delete com.microsoft.Excel.plist from ~/Library/Preferences/

        b. Delete ~/Library/Preferences/Microsoft/ (the whole folder)

    1. If step 1~3 doesn’t fix the problem, create a new user account and see whether Excel works on the new user account.

     

    If these steps don't improve the performance, you can end me (xinxin_at_microsoft.com, replacing _at_ with @). I should be able to find the root cause and provide some advice.

     

    XinXin

    Thank you for your reply this is great info I will try what you advised

    Mark

    I'm having the same issue and I've tried the above instructions and it's still really slow. I have over 240,000 rows of data. I would say it's the amount of data I have but I don't have this problem when using it on my PC that's running Office 2007. Please help.

    Oscar

    Was this answer helpful?

    0 comments
  4. Anonymous
    2012-02-14T15:19:51+00:00

    It seems this problem is unresolved. Our office has switched to Mac's and use Office 2011 for mac and the people that use Excel 2011 have the same problem

    Was this answer helpful?

    0 comments
  5. Anonymous
    2012-02-12T05:08:27+00:00

    I've sent a binary .xlsb file with random data that reproduces these issues.

    Was this answer helpful?

    0 comments