Pivot Table Refresh/Requery

Hello,

I have a pivot table that is based on a SQL Server connection. The pivot table queries a database view and groups the data and sums up a few columns.

I'm facing a problem where if data changes in the underlying database, the change is not reflected in the pivot table. I want the pivot table to view the data in the underlying view; so rows deleted from the view dissappear from the pivot table, and rows added appear.

I know people have faced this problem before and some posted macros to make the pivot table refresh. I tried some of these solutions and they didn't work for me.

If someone reading this post has faced this problem and solved it, could you please tell me how you solved it and may be also post your working macro code?

Thank you.