Microsoft KB Archive/817774

= XL2002: Adding Subtotals Takes Longer After You Use Print Preview =

Article ID: 817774

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-





SYMPTOMS
If you add subtotals to the worksheet after you use the Print Preview feature in Excel 2002, it takes longer than you expect before the subtotals are added.



CAUSE
This problem occurs because after you use Print preview, Excel 2002 adds page breaks to the Normal view of the worksheet. If you add subtotals to the worksheet, Excel 2002 has to reconfigure the page breaks to fit the subtotals on the page. This process involves interacting with the printer driver to determine the new position for the page breaks.



WORKAROUND
To work around this problem, turn off page breaks in the Normal view for Excel 2002:
 * 1) On the Tools menu, click Options.
 * 2) Click the View tab.
 * 3) Click to clear the Page breaks check box.
 * 4) Click OK.

Note If you complete these steps, and then save your workbook, the Page breaks setting remains off for this workbook only. If you create or open a new workbook, and the use Print Preview, the Page breaks setting is turned back on.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: xlxp data slow

Keywords: kbui kbbug kbprb kbnofix KB817774

-

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

© Microsoft Corporation. All rights reserved.