Microsoft KB Archive/164919

= XL97: Scrolling Through Worksheet Causes MS Excel to Pause =

Article ID: 164919

Article Last Modified on 10/22/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q164919



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: KB164919

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.