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

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

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

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


"DianeG" wrote:

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