Scrolling is terribly slow if I have filters active. I have a 40,000 row sheet,

Question

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#.

Explanation / Answer

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

0. Make sure both MacOS and Mac Office are patched with the latest updates.
1. Run "disk utility" (a system utility) to repair the disk permission
2. Run "font book" (a system utility) to resolve duplicated fonts
3. With all Office applications shut down,
    a. Delete com.microsoft.Excel.plist from ~/Library/Preferences/
    b. Delete ~/Library/Preferences/Microsoft/ (the whole folder)
4. If step 1~3 doesn

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.