Pivot Table Using Multiple Sheets is changing my values

If your pivot table is changing the values in your Excel document, it's likely because the pivot table is performing some calculations or aggregations on the data. By default, pivot tables summarize data using functions like SUM, COUNT, AVERAGE, etc. These functions can modify the original values.

To ensure that the values in your pivot table remain the same as in their original sheets, you need to adjust the settings of the pivot table. Here are a few steps you can follow:

1. Select any cell within the pivot table to activate the PivotTable Tools on the Excel ribbon.
2. Go to the "Design" tab under PivotTable Tools.
3. In the "Layout" group, click on the "Report Layout" button and choose "Show in Tabular Form". This will display the pivot table in a tabular format without any calculations or aggregations.
4. In the "Layout" group, click on the "Subtotals" button and choose "Do Not Show Subtotals". This will remove any subtotals that might have been automatically added to the pivot table.
5. Similarly, click on the "Grand Totals" button and choose "Off for Rows and Columns". This will disable the display of grand totals in the pivot table.
6. Finally, you may want to remove any calculations that are being performed on the values in the pivot table. To do this, select any value cell in the pivot table, right-click, and choose "Value Field Settings". In the dialog box that appears, select the "None" option, and click "OK".

By following these steps, you should be able to create a pivot table that displays the original values from your sheets without performing any calculations or modifications.