Every now and then, you might run into an issue where a pivot table isnt working correctly.
This can be either the table not presenting the correct data or throwing an error.
Here are some of the most common ways to troubleshoot the problem.
Theres a simple setting you’ve got the option to flip to remove that.
Right-hit any cell in the pivot table, including the headers.
Youll get an Options pop-up box.
Go to the Data tab.
For the Number of items to retain in the field value, choose None.
Step 5. hit OK and exit the window.
However, in some cases, you might get a count of items instead.
This is a relatively simple fix.
Right-hit the field that is displaying the wrong result.
From the context menu, choose the function you want from the list.
Usually, this comes from the tables source being fixed and not accounting for new rows.
Step 2. tap on Select Data Source and go to Choose Data Source again under it.
Youll get a pop-up menu that contains a Table/Range field.
Alternatively, overwrite the fields value to include the added rows.
Hit Ok, and the table should update.
In this case, however, there doesnt seem to be an easy fix to the issue.
In some cases, disabling OneDrive automatic saving and recreating the pivot table could address the issue.
In others, just refreshing the pivot table manually updates the data.
Right-choose the pivot table.
Choose PivotTable options on the bottom of the context menu.
Check the Refresh data when opening the file box.
Step 5. punch OK and exit the pop-up menu.
You may need to rebuild the pivot table for Excel to reapply the auto-sum function.
