| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Fields
I added a couple of columns to an Excel 2007 spreadsheet. When I went to
generate a pivot table, all but one of the fields that I added do not show in the field list. I've refreshed the table, got out Excel & tried again all with no luck. Anybody have any suggestions as to why all the fields are not showing? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Fields
You'll have to change the source data range to include all the new columns.
Select a cell in the pivot table On the Ribbon, click the Options tab Click Change Data Source, and click Change Data Source Change the Table/Range reference to include all the new columns. Fritz wrote: I added a couple of columns to an Excel 2007 spreadsheet. When I went to generate a pivot table, all but one of the fields that I added do not show in the field list. I've refreshed the table, got out Excel & tried again all with no luck. Anybody have any suggestions as to why all the fields are not showing? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
| Pivot table fields | Excel Discussion (Misc queries) | |||
| number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
| Pivot table # of fields | Excel Discussion (Misc queries) | |||
| Pivot Table Fields | Excel Worksheet Functions | |||
Hybrid Mode
