Why does my PivotTable not pick up all the column headings from payroll? #
This is likely due to not selecting all the data columns; for example, if you have added some pay definitions since you first created the report or are using more Shift Pay Items, the number of columns in the underlying data will increase.
In Excel:
- Click anywhere in the PivotTable
- Menu Pivot Table Analyse > Change Data Source and carefully modify the Location to include the last column of data:
