How do updates work when creating a pivot table based on another?

[Guest]

I've never quite got how this works. If I create a pivot table based on
another, does it matter which one I base it on?

Also If I update the main data source do I have to go to each pivot table
and update each one manually - or if one is updated do all the others based
on it update too?

Thanks

Diane

 

[Guest]

Does nobody know the answer to this or is it a silly question?