If you try to use a duplicate name, Excel shows an error message, and does not change the existing name. You cannot give a pivot table the same name as another pivot table on the same worksheet.There is also a restriction on duplicate names: Here are the limits on the number of characters in a valid pivot table name: The Analyze tab box is about 1″ wide, and the PivotTable Options box is about 2.5″ wideĪlthough the naming rules for other items, such as macros, or worksheets, are somewhat strict, the pivot table names are quite flexible.
In the screen shot below, you can see a comparison of the box sizes. PivotTable Options name box is bigger than the one on the Analyze tab, so you might want to make changes here, except for very short names.
When a pivot table cell is selected, you can see the pivot table’s name at the left end of the Analyze tab on the Excel Ribbon. You can see written instructions and screen shots on my Contextures website. Watch this video to see the steps for creating a pivot table, using the Recommended Pivot Tables command. Excel will create a name, and it’s easy to change the pivot table name at any time. While you’re building an Excel pivot table, you don’t have an option to set a name for your pivot table. You can leave that automatic name as it is, or change an Excel pivot table name to something more meaningful, such as “SalesPivot”.
When you build a pivot table, Excel automatically creates a numbered name for it, such as PivotTable1.
0 kommentar(er)
