Pivot Table - Value that was missing now showing after restarting

[annieexcel]

Hi Everyone -

I initially missed a value when I was typing into my data set. I then ran my pivot table and noticed it was missing.

I copy pasted my new data with my correction and could see that it was there. I ran my pivot table again and it was still missing. I filtered to see if it was there and it was. I tried the same process again several times and still couldn't figure out what was wrong. Now that I've restarted and opened everything again it's working just fine.

Should I have started from a completely blank worksheet? Was it not okay to just paste over? I'm not sure what was going on here.

 

[SpillerBD]

When adding new data to your source table, you should reset the Source the Pivot Table is evaluating.
If using a Table, you can verify that the Table auto-extended to include the new data.

 

[annieexcel]

Oh thank you! I'm so relieved it was just operator error. I figured that if I just changed the data source then it should be fine. Appreciate your response.