If you work regularly with Pivot Tables, you may have times when you are asked why is the Pivot Table dropdown field list missing. Has it disappeared? This can be very annoying especially when you know that there are other options you may want to choose, yet you can’t choose them, you are stuck on one option.
As per below, we know that there are other clients we want to view but for some reason there is no way to change this. The field list dropdown is missing. Similarly with the months. We can see January but how do we change it to February?
This is just a Pivot Table setting.
If you
- click on the Pivot Table,
- click on Analyse and
- switch the Field Headers back on.
You will notice that the field list dropdown buttons reappear as shown below.
Now you can click on the dropdown button and choose the client you want to report on (as below). Similarly with the months, you now have the drop down list.
Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.
Related
Change the name of items directly in the Pivot Table
Turn off automatic date and time grouping in Excel Pivot Tables