Scrolling Very Slow

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Bryant - 22 Jan 2008 21:19 GMT

One worksheet in a workbook is very slow to scroll (page up/down, mouse
scroll, and scroll bar). Excel 2003 was fine. Now scrolling takes several
seconds per page.

This worksheet has over 5000 rows and 20 columns. If I delete 75% of the
rows scrolling is much faster, though it shouldn't make a difference. The
other sheets are fine, though much smaller.

The slow worksheet also has over 30+ text boxes spread across the rows.

I have played with calculation settings to no avail. I have plenty of memory
(4GB) and a 4GB pagefile.

Any help would be greatly appreciated.

Reply to this Message

JP - 22 Jan 2008 21:27 GMT

Does the worksheet have a lot of formulas (esp array formulas or
formulas with a large scope) and/or fonts/colors? These tend to slow
down the workbook since it has to repaint the screen constantly while
scrolling. Also if it is filtered that also slows down scrolling in my
workbooks.

HTH,
JP

> One worksheet in a workbook is very slow to scroll (page up/down, mouse
> scroll, and scroll bar). Excel 2003 was fine. Now scrolling takes several
[quoted text clipped - 10 lines]
>
> Any help would be greatly appreciated.

Reply to this Message

David Bryant - 22 Jan 2008 22:14 GMT

There are many formulas, but all are simple addition or multiplication.

I have tried shaving parts of the data off to see if I can find the problem.
The sheet has 15 identical blocks of several hundred lines to it is easy to
tinker and replicate. I think that the text boxes are causing the problem. I
removed them it seems to be faster.

This wasn't a problem in Excel 2003.

Any thoughts?

Does the worksheet have a lot of formulas (esp array formulas or
formulas with a large scope) and/or fonts/colors? These tend to slow
down the workbook since it has to repaint the screen constantly while
scrolling. Also if it is filtered that also slows down scrolling in my
workbooks.

HTH,
JP

On Jan 22, 4:19 pm, "David Bryant" <d...@db.com> wrote:

> One worksheet in a workbook is very slow to scroll (page up/down, mouse
> scroll, and scroll bar). Excel 2003 was fine. Now scrolling takes several
[quoted text clipped - 11 lines]
>
> Any help would be greatly appreciated.

Reply to this Message