XL2002: "Print Cell Errors As" Setting Is Lost When You Open and Save Workbook in Earlier Version (282406)
The information in this article applies to:
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 "round-trip" 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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Minor | Last Reviewed: | 1/6/2006 |
|---|
| Keywords: | kbprb KB282406 |
|---|
|