Hi All,


I am using Excel 2013 for importing data from SQL Server & displaying it in Pivot Table.
Then I am changing some of the email Ids to my test user's email id in that imported data in Pivot Table.


My problem is when I refresh the Pivot Table Data Connection, its refreshing all the data & statistics properly (from database) but that email id/data that i have changed earlier its not refreshing, meaning Pivot Table is retaining modified data. How to Update fresh data in this case.
I have set "None" in Pivot Table Options > Data > Retain Items Deleted From Data Source-Number of items to retain per field, but it not works.


Waiting for your reply.


Thanks.
Kind Regards,
Chintan Sanghavi