Here are some steps to troubleshoot common PivotTable errors in Excel:

Missing Fields:

1. Check Source Data: Ensure all the columns you want to include in the PivotTable are present in your source data range. Hidden columns or blank headers can cause missing fields.
2. Data Type Mismatch: Verify that the data type (text, number, date) of your field matches what the PivotTable expects. You might need to format the source data appropriately.
3. Calculated Fields: If the missing field is a calculated field in your source data, ensure the formulas are correct and referencing the intended fields.

Incorrect Calculations:

1. Source Data Errors: Double-check your source data for any errors or inconsistencies that might be impacting calculations.
2. Formula Errors: Review the formulas used in your PivotTable for typos or incorrect references. Test the formulas directly in cells to isolate any issues.
3. Aggregation Issues: Make sure the chosen aggregation function (Sum, Average, Count, etc.) aligns with your intended calculation. You might need to switch between functions depending on the scenario.
4. PivotTable Settings: Check the PivotTable settings for calculations like "Show values as" percentage or difference from previous period. These settings can affect the displayed values.

Additional Tips:

- Refresh Data: Always refresh your PivotTable after making changes to the source data to ensure it reflects the latest information.
- PivotTable Analyze Tab: The "Analyze" tab within the PivotTable ribbon offers options like "Change Data Source" and "Error Checking" which can help identify issues.
- Online Resources: Search online for specific error messages you encounter. Many resources offer detailed troubleshooting steps for various PivotTable errors.

By systematically checking these areas, you should be able to identify and fix most common PivotTable errors, ensuring your PivotTable displays accurate and insightful data summaries.