Microsoft KB Archive/178500

= XL98: Wrong Values Displayed for Calculated Item in PivotTable =

Article ID: 178500

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q178500



SYMPTOMS
When you manually edit a formula for a calculated item in a PivotTable, the formula may return incorrect results.



CAUSE
This problem occurs when all of the following conditions are true:

The PivotTable contains one or more page fields.

-and-

You add a calculated item to the PivotTable.

-and-

You select one of the items in the page field drop-down list, other than (All).

-and-

You manually edit the formula for the calculated item.



WORKAROUND
To work around this problem, use either of the following methods to edit the formula for the calculated item:


 * Use the "Insert Calculated Item in " dialog box to edit the formula for the calculated item. -or-


 * In the page field drop-down list, click to select (All) before editing the formula for the calculated item.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



MORE INFORMATION
