XL98: Inserting Rows or Columns Slower with Page Breaks Visible

ID: Q189896

The information in this article applies to:

SYMPTOMS

When you insert rows or columns in your worksheet, the speed at which the rows or columns are inserted may decrease after you do any of the following:

CAUSE

The speed at which rows or columns are inserted may decrease if you have the Page Breaks check box enabled on the View tab of the Preferences dialog box.

NOTE: The decrease in speed is much more pronounced on computers with relatively slow processors.

RESOLUTION

To prevent a decrease in the speed at which rows or columns are inserted, disable the Page breaks option. To do this, follow these steps:

1. On the Tools menu, click Preferences.

2. Click the View tab.

3. Clear the Page Breaks check box.

4. Click OK.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.

Additional query words: XL98 pause hesitation hesitate

Keywords          : kbdta xlui 
Version           : MACINTOSH:98
Platform          : MACINTOSH
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: July 27, 1998