Excel Pivot Table Repeat Item Labels Not Working
Excel Pivot Table Cannot Select Repeat Item Labels
Excel Pivot Table Repeat Item Labels Disabled
Excel Pivot Table Repeat Item Labels Greyed Out

I often use pivot tables to summarise one data source so that I can use that pivot table output as the basis for further analysis.

By working on summarised data I can reduce the overall file size by losing unnecessary detail and it is also a useful way to control the format of the data as well.

To repeat the outer row label items on the printout of each page of the Pivot Table, select the check box of 'Repeat row labels on each printed page' in the 'Print Section' of the 'Printing' tab. This is applicable when there is more than one row label item in the Pivot Table report. Set print titles.

1 point 1 year ago. I’m not getting the repeat item label option in when i right click on the label and select field settings though, and it’s apparently because “Sum of Constrained MMCPO” is in the “Values” field of the pivot instead of column/row/filter.but there must be a way around this. Continue this thread. But, the old items might still reserve in the filter drop down, this will be annoying. In this article, I will talk about how to clear the old items in pivot table. How to repeat row labels for group in pivot table? In Excel, when you create a pivot table, the row labels are displayed as a compact layout, all the headings are listed in one column. Note that you don’t have to change it to Classic View to do this. Just go Design/Report Layout/Show in Tabular Format. At which stage the Report Layout menu ‘helpfully’ vanishes. So then you need to click on it again, and select Repeat All Item Labels. But I too use code.

I find myself spending quite a bit of time adjusting the format of the pivot table so that it looks like a flat file data source that I can then copy and paste values as a new data source.

The stages to format a modern styled pivot table to a flat file style are:

1. Convert to classic style
2. Remove all subtotals
3. Repeat item labels

If you do a similar thing you might appreciate this macro that automates the process

If you want to reverse this macro and put your classic styled pivot table back to the new fangled Excel 2007 style, you’ll need to use this macro:

Here’s the example workbook with a working macro to both flatten the modern style pivot table (repeating item labels and removing subtotals) and a macro to return the classic style pivot table to the modern design. Pivot Macros workbook.xlsm

When you create a pivot table in Excel 2010 or Excel 2007, the row labels are in a compact layout – all the headings are listed in column A.

Excel Pivot Table Repeat Item Labels Not Working

You can change the Report Layout setting, to either Outline form or Tabular form, so each row field is in a separate column.

Excel pivot table repeat item labels not working

Here’s the same pivot table in Outline form. The Region field is in column A, with a separate row for each new heading.

Repeat the Row Labels

A new feature in Excel 2010 lets you repeat those row labels, so they appear on every row in the pivot table.

To turn on that feature for all the fields, select the Repeat All Item Labels on the Ribbon’s Design tab.

Here’s the pivot table in Outline form, with repeating row labels.

Repeating Labels for a Single Field

Excel Pivot Table Cannot Select Repeat Item Labels

Instead of turning on repeating labels for the entire pivot table, you can apply the feature to a specific pivot table field.

In this example, the Region, City and Store fields are in the Row area, and we’ll turn on repeating labels for the Region field only.

Right-click one of the Region labels, and click Field Settings
In the Field Settings dialog box, click the Layout & Print tab
Add a check mark to Repeat item labels, then click OK

Now, the Region labels are repeated, but the City labels are only listed once.

Watch the Pivot Table Repeat Labels Video

Excel Pivot Table Repeat Item Labels Disabled

To see the steps for repeating labels in all fields, or a single field, please watch this short Excel pivot table video tutorial.

Excel Pivot Table Repeat Item Labels Greyed Out

_________________