Pivot Table Problem When Changing Data Source

[viber52]

I have multiple pivot tables set up on different tabs all connected to one data source in the first sheet. I need to periodically update the pivot tables by adding additional fields to the data source. When all formatting is correct, I click analyze, change data source and select the range. Once I apply the changes, my pivot table loses all of its values and goes back to its original form (not set up with any values). What can I do to quickly add my data to the pivot tables?

[humdingaling]

change the data source to a table and everytime you update the table it will automatically update the data source of the pivot tables as well