Watch this video to see how to hide those error values, or change them to a different value. When there are errors in the pivot table source data, you might see errors in the pivot table Values area.

If you try to do that, Excel will show an error message, and will not change the name. Naming Restriction: You cannot give a pivot table the same name as another pivot table on the same worksheet. I recommend using alphanumeric characters only though, to avoid problems when creating macros that refer to pivot tables by name.Non-alpha-numeric characters are allowed, e.g.: My Pivot.NOTE: The settings available on each tab may vary slightly, depending on which type of pivot table is selected (Normal, OLAP-based, pre-2007, MDX support)Īt the top of the PivotTable Options window, there is a box that shows the current name of the selected pivot table.Įxcel automatically creates a numbered name for each new pivot table, and you can leave the default name as is, or change that name to something more meaningful, such as 'SalesPivot'.Īlthough the naming rules for other items, such as macros, or worksheets, are somewhat strict, the pivot table names are quite flexible. In the PivotTable Options window, the PivotTable name is shown at the top, and there are six tabs below that. Right-click on any cell in the pivot table.

See how to open that dialog box, and change the settings Open PivotTable Options There’s another place where you can control the pivot table’s behaviour too – in the Pivot Table Options. When you’re setting up a pivot table, you can use the Ribbon commands to change its appearance, and the source data, and several other settings. More Pivot Table Tutorials Pivot Table Options

Excel 2013 create pivot table options