Oct 17 2018 03:59 PM
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.
Oct 17 2018 10:27 PM