Microsoft KB Archive/282406

= XL2002: &quot;Print Cell Errors As&quot; Setting Is Lost When You Open and Save Workbook in Earlier Version =

Article ID: 282406

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q282406



SYMPTOMS
When open an Excel 2002 workbook in an earlier version of Excel, save the workbook in the earlier version, and then reopen the workbook in Excel 2002, the Print Cell Errors As setting is reset to its default value (Print Cell Errors As Displayed).



CAUSE
The Print Cell Errors As setting is a new feature in Microsoft Excel 2002. Earlier versions of Excel do not recognize the feature, and so the setting is not able to &quot;round-trip&quot; through earlier versions.



WORKAROUND
When you reopen the file in Microsoft Excel 2002, reset the Print Cell Errors As setting before you print the workbook. To do this, click Page Setup on the File menu, and then click the Sheet tab. Under Print, click the setting that you want in the Cell errors as list.



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:

Keywords: kbprb KB282406

-

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

© Microsoft Corporation. All rights reserved.