The information in this article applies to:
SYMPTOMSUnder certain circumstances, you may receive incorrect values in the Subtotal and Grand Total cells in PivotTables that you create in Microsoft Excel 7.0 and 7.0a. MORE INFORMATION
Only PivotTables that you create under the following circumstances are
affected. Note that all five conditions must be true in order for the error
to occur:
WORKAROUNDSThere are several methods you can use to work around this behavior.Method 1Remove the error values from your source data. You can remove the error values by correcting your data to remove the errors, or by using a function that checks for error values. The following is an example of a function that checks for error values.Type the following function in every cell in your source data that could return an error:
where Your Function is the formula or function you are using in your source
data. For example, type the following formula in cell C2 for a formula
=A2/B2 located in cell C2:
If the formula is valid, the proper value will be returned. If the formula
results in an error, instead of returning an error message, the function
returns "NA." Note that "NA" is a placeholder message that you can change
to meet your needs.
Method 2If you have only one Pivot Table field in one dimension (there is only 1 row field or only 1 column field in your table), using the right mouse button (right-click), click that field and click the Pivot Table Field command. In the Subtotals category of the dialog box, click to select Count. This option will correct the error, and will not change the appearance of your PivotTable.Method 3If you have multiple fields, right-click the innermost row field (the field name that appears furthest to the right in the list of row fields), and click the Pivot Table Field command. In the Subtotals category of the dialog box, enable Count. This option will correct the error, and will add several rows that display data counts for your data at the bottom of the PivotTable. You can hide these rows prior to printing by using the Hide Rows command.Additional query words: 7.00a pvtpatch
Keywords : xlpivot |
Last Reviewed: October 5, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |