I have a pivot table that has as its' rows labels (ID, Name, Email). The pivot table is built on a view in SQL Server database.

For example,

ID Name Email
1 Bob Smith bsmith@test.com
1 Tom Jones tjones@test.com
1 Jane Doe jdoe@test.com

If I go to Tom Jones email cell and type in a different email address, it takes it. The data in the database does not change, but when I refresh the pivot table, it doesn't pull back in the correct email from the database. How do I fix that?

Example after changing cell,

ID Name Email
1 Bob Smith bsmith@test.com
1 Tom Jones tomjones@test.com
1 Jane Doe jdoe@test.com