Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables missing fields from defined table
I have added a new column to a table and updated the table to include this
column. When I then go to create the pivot table this new column does not appear in the fields to be selected thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables missing fields from defined table
1) Click on your pivot table to activate it, you'll see the blue outline
around it. 2) Click the "!" on the pivot table toolbar. 3) click Pivot table dropdown button on the toolbar and choose wizard. 4) Now you can redefine the layout and source range (click "back" to redefine source range if necessary". "Emma" wrote: I have added a new column to a table and updated the table to include this column. When I then go to create the pivot table this new column does not appear in the fields to be selected thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables missing fields from defined table
Hi dfunk
I couldn't find the "!", but this might be due to the fact I am running on excel 2007 ... but I actually found that I needed to "refresh" the data and then it worked thanks for getting back to me so quickly "dfunk" wrote: 1) Click on your pivot table to activate it, you'll see the blue outline around it. 2) Click the "!" on the pivot table toolbar. 3) click Pivot table dropdown button on the toolbar and choose wizard. 4) Now you can redefine the layout and source range (click "back" to redefine source range if necessary". "Emma" wrote: I have added a new column to a table and updated the table to include this column. When I then go to create the pivot table this new column does not appear in the fields to be selected thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customise Pivot Tables Fields | Excel Discussion (Misc queries) | |||
Calculated Fields in Pivot tables - Help | Excel Worksheet Functions | |||
number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
Calculated fields-Pivot tables | Excel Worksheet Functions | |||
row fields in pivot tables | Excel Discussion (Misc queries) |