XL97: Redraw Problems Applying Page Setup in Many Sheets (168505)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q168505

SYMPTOMS

After you click OK in the Page Setup dialog box, the screen may fail to update completely in Microsoft Excel, leaving the screen white except for the program title bar.

CAUSE

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

  • You select a large number of worksheets in a workbook (for example, 50 or more). -and-

  • You change page settings using the Page Setup dialog box. -and-

  • You use any of the following printer drivers:

    Canon BJ600
    Hewlett-Packard IIIsi
    Hewlett-Packard IIIsi PostScript
    Hewlett-Packard 4M
    Hewlett-Packard 4M PostScript
    Hewlett-Packard Deskjet 870cse & 870cxi
    Hewlett-Packard Deskjet 850cse & 850cxi

WORKAROUND

To work around this problem, minimize the screen, and then restore the screen. To do this, use the following steps:

  1. Press ALT+SPACEBAR. Press N.

    The screen is minimized.
  2. Switch to Microsoft Excel to restore the screen.

    If you are using Microsoft Windows NT 4.0 or Microsoft Windows 95, click Microsoft Excel on the Task Bar to restore it. If you are using Microsoft Windows NT 3.51, press CTRL+ESC. On the Task List, click Microsoft Excel and click Switch To. The screen is redrawn correctly.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
Modification Type:MajorLast Reviewed:11/8/2000
Keywords:kbprb kbui KB168505
©2002 Microsoft Corporation. All rights reserved.