Keep changing the source table - how can I update pivot table

[INN]

Hi
I have a pivot table. Every month my source table will be change. Right now I delete the old table and then paste the new table over and then refresh pivot table. Is there better way of doing that? Thank you very much.

 

[arthurbr]

Perhaps Change Data Source for All Pivot Tables - Contextures Blog

 

[INN]

Thank you.

 

[arthurbr]

You're welcome