XL97: Formula Errors Appear After Updating PivotTableLast reviewed: February 12, 1998Article ID: Q166740 |
The information in this article applies to:
SYMPTOMSWhen you update a PivotTable, formulas that refer to a date in the PivotTable return an error value.
CAUSEThis problem occurs when all of the following conditions are true:
Article-ID: Q109420 TITLE : XL: Dates in Pivot Table May Be Converted into Text WORKAROUNDTo work around this behavior, edit the formula to refer to the date as a date value instead of a text value. For example, retype the following lookup formula
=VLOOKUP("7/25/59",$D$1:$G$10,4)as follows:
=VLOOKUP(DateValue("7/25/59"),$D$1:$G$10,4) MORE INFORMATIONIn earlier versions of Microsoft Excel, dates in a PivotTable are automatically formatted as text. This means that if you reformat a cell that contains a date with a number format, the format in the cell is reset to a text number format when you update the PivotTable. However, Microsoft Excel 97 allows you to use rich text formatting in a PivotTable, including dates. Microsoft Excel 97 automatically formats any date in a PivotTable with a date format. This is an enhanced formatting feature and is different from earlier versions of Microsoft Excel. Therefore, a formula that refers to a date that uses the text format in a PivotTable returns an incorrect result or an error value, such as the #N/A or #VALUE! value.
|
Additional query words: XL97 pivot table break calculation err upgrade
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |