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. In the right-click menu, click PivotTable Options.Īt the top of the PivotTable Options window, there is a box that shows the current name of the selected pivot table.Right-click on any cell in the pivot table.NOTE: There’s no setting that lets you increase the size of the pivot table name box on the Analyze tab.Īnother place to see the pivot table name is in the PivotTable Options dialog box.
The name box is small though, and the end of the name is not visible. In the screen shot below, I changed the name to “PivotTableNEW”. Click anywhere outside of the name box, to complete the name change (you don’t have to press Enter).Type a new name, or make a change to the existing name.You can use that pivot table name box to make a quick change to the pivot table name: 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)
