Setting to use a new Pivottable Name when copying a pivot?

%3CLINGO-SUB%20id%3D%22lingo-sub-274902%22%20slang%3D%22en-US%22%3ESetting%20to%20use%20a%20new%20Pivottable%20Name%20when%20copying%20a%20pivot%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-274902%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20setting%20to%20use%20a%20new%20Pivottable%20Name%20when%20copying%20a%20pivot%3F%3C%2FP%3E%3CP%3EIf%20you%20don%2Ft%20rename%20the%20PIvottable%20Name%20to%20be%20unique%2C%20then%20if%20you%20change%20things%20like%20group%20date%2C%20it%20applies%20to%20all%20the%20tables%20you've%20copied%20n%20a%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20looked%20in%20Pivot%20Table%20defaults%20in%20Excel%20Options%20and%20in%20Pivot%20Options.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20is%20there%20a%20view%20like%20name%20manager%20where%20you%20can%20see%20if%20you%20have%20any%20duplicate%20Pivottable%20Names%3F%3C%2FP%3E%3CP%3EI%20noticed%20this%20using%20slicer%2C%20but%20only%20if%20the%20same%20value%20is%20across%20all%20Pivots.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-274902%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275101%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20to%20use%20a%20new%20Pivottable%20Name%20when%20copying%20a%20pivot%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275101%22%20slang%3D%22en-US%22%3EHi!%20Just%20a%20heads%20up!%20Post%20this%20in%20the%20excel%20forum%20as%20well%20if%20not%20done%20already!%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Is there a setting to use a new Pivottable Name when copying a pivot?

If you don/t rename the PIvottable Name to be unique, then if you change things like group date, it applies to all the tables you've copied n a workbook.

 

I looked in Pivot Table defaults in Excel Options and in Pivot Options.

 

Also is there a view like name manager where you can see if you have any duplicate Pivottable Names?

I noticed this using slicer, but only if the same value is across all Pivots.

1 Reply
Highlighted
Hi! Just a heads up! Post this in the excel forum as well if not done already!

Adam