Excel Pivot issue

Question

May we request for your assistance regarding Excel Pivots not updating properly (intermittently) .

1. Update source data tab (my row-range is larger than my data, so I don’t have to reset the pivot size;
   that used to be a bug where I could not, hence this approach)
2. Refresh original pivot, I get this. Refresh N times does not improve things.
3. Bugs
4. One or more rows are missing even though they’re in the data (see step 4)
5. The data in the count table is wrong (which makes the % table wrong)
6. Create a new pivot off of the data
7. The missing row(s) is included and data is "fixed"
8. Refresh the original pivot and the missing row(s) appears!

Please check and provide any suggestion.

Answer 1

@Microsoft Q & A

Which version of Office are you using? Such as Office 2016, Microsoft 365 apps.

Does your Pivot Table have any Filters fields?
If yes, it is recommended to tick the boxes of all items to show all data. Besides, you may right click the "All" cell > Field Settings > Tick the box of "Include new items in manual filter".

Besides, I suggest you refer to this article to change the source data for a PivotTable to check this issue.

Any misunderstandings and updates, please let me know.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thanks for the information. Unfortunately the issue is still not get resolved. We are using office 2016. Could you provide any other solution.