XL97: Wrong Values Displayed for Calculated Item in PivotTable

ID: Q172097

The information in this article applies to:
  • Microsoft Excel 97 for Windows

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:

  1. The PivotTable contains one or more page fields.


    2. -and-

  2. You add a calculated item to the PivotTable.


    3. -and-

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


    4. -and-

  4. 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 <field>" 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.


REFERENCES

For more information about changing the formula for calculated items, click the Index tab in Microsoft Excel Help, type the following text

calculated items in PivotTables, changing
and then double-click the selected text to go to the "Change the formula for a calculated item in a PivotTable" topic.

Additional query words: XL97

Keywords : xlformula xlpivot
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: October 30, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.