field list

There is a "Status" field in my workbook that captures 20 different statuses based on phase in project. (Not all 20 items are actively used.) In my pivots I only need to capture 15 of the 20 statuses. Problem: I can't pre-select or auto-select the items I want because not all of them are...

I accidentally unmored the field list and I can't see to get it anchor in upper right corner of my worksheet. Can anybody help with this. Thanks

Hello, I know that you can adjust the layout of a pivot table field list, but I want to know if you can adjust the size of the Areas Sections. (Filters, Rows, Columns, and Values sections) This is just a big peeve of mine when I'm trying to build out a big pivot table with lots of rows. Anytime...

I've just noticed this, which is a nuisance. It started a few weeks ago after I had my laptop re-imaged (everything re-installed). On a pivot table, if the active cell is within the table (data or labels), and the Field List is displayed, the cursor will flicker, anywhere it goes within the...

Hi, I'm trying to reproduce a pivot table in Power Pivot to take advantage of the additional tools it offers. However, when creating the pivot table from Power Pivot and adding fields I cannot get the data sit in rows on top of each. In my existing pivot table I add the field to the values...

I want to find out if a particular field, say a month from Jan-14 to Dec-14, exists in 'pivot field list' before adding it to the pivot table? can you please help me out on this as I have tried couple of things but doesnt work. Here is my code: Sub Test() If (FieldItemExists("Feb -...

Hi all, I've set up a pivot table which is working fine. However two of the fields I originally included are missing from the field list - but still appear in the 'values' area and in the table itself. If I drag them out of the values area, they disappear completely - rather than returning to...

I have a password-protected workbook that at one point in time I set the "PivotTable Field List" to not be shown. Now I need to make an update to the Pivot Table Fields and the icon shows but it is grayed out. I have tried "Application.CommandBars("PivotTable Field List").Enabled = True" but it...

Hello! I'm struggling with a Macro / Pivot problem in Excel - I'm hoping you can help! The problem I have recorded a macro that works as intended, with the exception of it automatically adding 'all column fields' to the Pivot table. I'm afraid that the columns are likely to be variable each...

Win 7, Excel 2010, VBA. Using a "Sub Worksheet_PivotTableUpdate" 'trigger', I want to determine WHICH filter changed if a user made a new selection from a drop down list on the filter pivot field. (not the value that was chosen, but the field that was changed.) The macro initiates whenever...

I was given an Excel 2007 spreadhsheet at work. In one worksheet I selected all of the cells containing data under columns A-E; that was 146 rows including the header row. After selecting Insert > PivotChart to be placed into a new worksheet, I noticed that many more columns were represented in...

Have my settings changed or is there a software problem? On my new and previously:confused: created Pivot Tables in Excel 2007 the field list is not displaying. I have tried turning on hide/display field list. Nothing changes. I have zoomed the sheet, it is not there. I have changed the...