how to view or edit database in pivot table?

[learning_grexcel]

I have created a pivot table from a database. Now I wanted to delete and make some changes in the database and it should be automatically affect the pivot table instead of doing it all over again from the source. How it can be done?

 

[mvanderv]

If you created a PivotTable from a database, presumably you still have a connection to the database?

If so, just go to the Data ribbon, and click the Refresh button after making the changes you want to your database.