XL97: Scrolling Through Worksheet Causes MS Excel to Pause

ID: Q164919

The information in this article applies to:

• Microsoft Excel 97 for Windows

SYMPTOMS

If you scroll through a worksheet by using the vertical scroll bar or the DOWN ARROW key, Microsoft Excel may pause momentarily; for example Microsoft Excel may pause every 20 rows or so.

CAUSE

This problem may occur if all of the following conditions are true:

• You created the workbook in Microsoft Excel 5.0 or 7.0.

  -and-

• Before you scroll through the worksheet, you set a page break or set a print area; or you switch to print preview and back to the normal view.

  -and-

• On the View tab in the Options dialog box, the Page Breaks check box is selected.

RESOLUTION

To resolve this problem, use either of the following methods.

Method 1: Clear the Page Breaks Check Box

To do this, use the following steps:

1. On the Tools menu, click Options.

2. In the Options dialog box, click the View tab.

3. Click to clear the Page Breaks check box.

4. Click OK.

NOTE: To view page breaks, view the document in page break preview (click Page Break Preview on the View menu).

Method 2: Cache the Data on the Worksheet

1. On the File menu, click Print Preview.

2. In Print Preview, click Close.

3. Click cell A1.

4. Press CTRL+END.

5. Press CTRL+HOME.

This method allows you to continue displaying page breaks on the worksheet.

STATUS

This is by design of Microsoft Excel 97 for Windows.

Additional query words: 97 XL97

Keywords          : xlui 
Version           : 97
Platform          : WINDOWS

Last Reviewed: November 4, 1998