Pivot Table - copy/save as new
Will a Pivot Table still update "live" if I "save as new" into another workspace? Or do I have to create another Pivot all together?
I have created a Pivot that I would like in two places in order to prevent the Sales Field from having access to underlying data.
- Place into a workspace for internal office
- Same pivot into a separate workspace for the Sales Field