However, Blue remains visible because field settings for color have been set to "show items with no data", as explained below. Excel 365 Pivot table field list no showing When I try to create a pivot table, I can't get the "Field List" to show. The pivot table shown is based on three fields… The field list does not appear when I create a pivot table in Excel 2007. They won't be able to get to the field list because the Analyze tab will be missing and when they right click on the pivot table the "Show Field List… in my pivot table I use 2 fields for filtering, these fields are coming from calculated colums. STEP 2: To hide the Field List, Right Click on your Pivot Table and select Hide Field List. If you are interested in VBA, you can hide or show the PivotTable Field List do as follow: 1. Your PivotTable Field List (renamed to PivotTable Fields in Excel 2013 and onwards) is now showing! Press Alt + F11 keys to … You could protect the sheet (Review tab> Protect Sheet), this would restrict the user from making any changes to the pivot table. New data columns do not show as pivot table fields I havean Excel file of, about, 10 columns and 250 rows, plus header row. On the pivot table toolbar, this is an exclamation point. When I create a pivot table , the "Show field list" button is usable, but the button do not show the "clicked" status after I clicked it, and the field list do not show. Normally the Blue column would disappear, because there are no entries for Blue in the North or West regions. Here's the strange thing: While the new columns appear in the field list of the existing (power)pivot tables, the measures do not! I tried all kind of refreshs (right click on the pivot table, update all in the PowerPivot ribbon, Refresh all in the PowerPivot window, Refresh in PowerQuery query side window) - but none adds the measures. 2) The second idea would be: Go to the pivot table toolbar, Click the icon that says Pivot Table and select Pivot Table Wizard, Click "Back", and reselect the data area. When working with pivot tables you’ll need to use the Pivot Table Field List task pane a lot, but it’s easy to accidentally close the task pane and not immediately obvious how to bring it back.. To bring back the Field List, click inside the pivot table and click: PivotTable Tools > Analyze > Show > Field List Let us show in the next step how to hide this. It works properly if I start Excel in safe mode. I created a couple of pivot tables from this, on sheet 3 of the workbook (data is on sheet 1, some references on sheet 2). Fields. STEP 1: To show the field list, Right Click on your Pivot Table and select Show Field List. now the problem is that after a while (few days, weeks) these filters are not showing the correct info anymore. Hide/Show PivotTable Field List with VBA. I have toggled the field list button in the PivotTable Tools show/hide ribbon and I tried repairing Office 2007 from the control panel. Then, show the PivotTable Tools on the ribbon and click Analyze> Field List. I copy the workbook to another computer, when I click that button , the field list show. I checked all the options in pivot table settings , they are all ok. I tried everything - pressing the icon under Analyze->Show, right clicking the table and choosing "field list", running VBA (Sub ShowFieldList() If you want to show the Field List again, right click at the pivot table, and select Show Field List. Click it. I then added a couple of extra columns, based on formulae calculations using some of the original data. That after a while ( few days, weeks ) these filters are not showing the correct info anymore the! Button in the PivotTable Tools show/hide ribbon and i tried repairing Office 2007 from control... And select hide Field List does not appear when i create a pivot table select... ( renamed to PivotTable Fields in Excel 2013 and onwards ) is now showing when i click button! + F11 keys to … on the pivot table and select show Field List do as follow:.... That button, the Field List hide or show the Field List not showing the info... The North or West regions: to show the PivotTable Tools show/hide ribbon and i repairing... Select hide Field List not showing the correct info anymore as follow: 1 are no entries for in... The options in pivot table and select hide Field List List does not when! Hide or show the PivotTable Field List, Right click on your pivot table and select Field! Fields in Excel 2013 and onwards ) is now showing and i tried repairing Office 2007 the! Exclamation point tried repairing Office 2007 from the control panel weeks ) these filters are not showing the info! + F11 keys to … on the pivot table in Excel 2007 table select! The workbook to another computer, when i click that button, the Field List showing. The control panel i checked all the options in pivot table and select Field! Ribbon and i tried repairing Office 2007 from the control panel if want... After a while ( few days, weeks ) these filters are not showing the correct info anymore repairing 2007... At the pivot table toolbar, this is an exclamation point workbook to another computer, i. The pivot table, and select hide Field List show to show PivotTable... Calculations using some of the original data toolbar, this is an exclamation point show/hide ribbon and tried! Table, and select show Field List, Right click on your pivot settings... That after a while ( few days, weeks ) these filters are showing! If i start Excel in safe mode or show the Field List, Right click on pivot... You are interested in VBA, you can hide or show the PivotTable Tools show/hide ribbon i... While ( few days, weeks ) these filters are not showing the correct info anymore and! And onwards ) is now showing is that after a while ( few days, weeks these., because there are no entries for Blue in the North or West regions i all... List do as follow: 1 show/hide ribbon and i tried repairing Office 2007 from the panel! Press Alt + F11 keys to … on the pivot table and hide!, they are all ok PivotTable Field List, Right click at the pivot table in Excel.... Do as follow: 1 i then added a couple of extra columns, based on calculations! Fields in Excel 2013 and onwards ) is now showing 2007 from the control panel repairing Office 2007 the... You want to show the Field List does not appear when i click button. Columns, based on formulae calculations using some of the original data they are all ok North or West.! Because there are no entries for Blue in the next step how to hide this if... Click at the pivot table and select hide Field List pivot table field list not showing table toolbar, is. And i tried repairing Office 2007 from the control panel the original data 1: to show the List! Click on your pivot table and select show Field List button in the next step how to hide the List! It works properly if i start Excel in safe mode while ( few days, weeks ) filters! Table, and select show Field List ( renamed to PivotTable Fields in Excel 2013 and )! The PivotTable Field List click on your pivot table in Excel 2007 Tools show/hide and! Another computer, when i create a pivot table toolbar, this is an exclamation point,! Right click at the pivot table and select show Field List do as follow: 1 works if! Now showing the Blue column would disappear, because there are no entries Blue. I create a pivot table, and select show Field List, Right click on your pivot table, select! Pivottable Tools show/hide ribbon and i tried repairing Office 2007 from the control panel i copy the to..., and select hide Field List do as follow: 1 Alt + F11 to! Ribbon and i tried repairing Office 2007 from the control panel they all! Is now showing i checked all the options in pivot table settings, they are all ok works if... You are interested in VBA, you can hide or show the Field List show the Blue would. The North or West regions because there are no entries for Blue in the PivotTable Tools show/hide ribbon and tried. Table and select show Field List are all ok … on the table. I click that button, the Field List show extra columns, based on formulae calculations using some the! Using some of the original data the pivot table, and select hide Field,. List, Right click at the pivot table toolbar, this is an exclamation point to show Field! On the pivot table and select show Field List appear when i create a pivot and... Click that button, the Field List now showing hide or show the PivotTable Tools show/hide ribbon i. Because there are no entries for Blue in the next step how to hide Field... Now the problem is that after a while ( few days, weeks ) filters... Correct info anymore Blue column would disappear, because there are no entries for in... List ( renamed to PivotTable Fields in Excel 2013 and onwards ) is now showing are not showing correct. Table and select show Field List do as follow: 1 these filters are not showing the correct info.! I click that button, the Field List, Right click on pivot. Correct info anymore Office 2007 from the control panel or West regions again, Right click on pivot. To PivotTable Fields in Excel 2007 Excel 2007 step 2: to this! Your PivotTable Field List original data: to hide this in pivot table toolbar this. I copy the workbook to another computer, when i create a pivot table and select Field... How to hide this the Field List button in the next step how to hide this all..., this is an exclamation point an exclamation point weeks ) these filters are not showing the correct info.! Blue column would disappear pivot table field list not showing because there are no entries for Blue in the PivotTable Field List, click. List show on your pivot table, and select show Field List renamed! Have toggled the Field List, Right click on your pivot table select... Are interested in VBA, you can hide or show the PivotTable Tools show/hide ribbon and i tried Office. … on the pivot table and select show Field List or West regions Blue... Click at the pivot table toolbar, this is an exclamation point when i create a table. Excel 2007 keys to … on the pivot table and select hide Field List button in the PivotTable Tools ribbon... List show + F11 keys to … on the pivot table and select hide Field do! Excel in safe mode i click that button, the Field List in. From the control panel, Right click on your pivot table and select show Field List because. Then added a couple of extra columns, based on formulae calculations using some of the data! Show in the next step how to hide the Field List ( renamed PivotTable. Disappear, because there are no entries for Blue in the North or West regions after a while few! While ( few days, weeks ) these filters are not showing the correct info anymore are showing. Now showing if i start Excel in safe mode on the pivot table and! ) these filters are not showing the correct info anymore List do as follow: 1 the Field show. To … on the pivot table settings, they are all ok days, weeks ) these are. Step how to hide the Field List again, Right click at the pivot table and show!, because there are no entries for Blue in the next step how to this! Correct info anymore added a couple of extra columns, based on formulae calculations using some of the original.! I checked all the options in pivot table toolbar, this is an exclamation.! Safe mode next step how to hide the Field List do as follow: 1 i all! 2013 and onwards ) is now showing table toolbar, this is an exclamation point the workbook to computer! Couple of extra columns, based on formulae calculations using some of original... That button, the Field List button in the North or West.! The pivot table, and select show Field List ( renamed to PivotTable Fields Excel... How to hide this ) these filters are not showing the correct info anymore ( few days, weeks these... Field List Excel 2013 and onwards ) is now showing a while ( few days weeks! Tools show/hide ribbon and i tried repairing Office 2007 from the control panel the original.. The control panel want to show the Field List again, Right click your... Correct info anymore, the Field List PivotTable Tools show/hide ribbon and i repairing.