Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Fields not showing
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.worksheet.functions
|
|||
|
|||
Pivot Table Fields not showing
Hi
Did you extend the range? The other suggestion is that you may have to add field buttons to your pivot table. Click yes if helped -- Greatly appreciated Eva "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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Fields not showing
Hi Fritz
It is best to create a Table first, then use the table name as the source for the PT. That way, as the table grows, either in width or in length, the source for the Pt adjusts automatically. Insert tabTable click my table has headers You will now see the Design tab, and in the top left corner, Table Name which will default to Tablex (Table1 first time). You can enter a new name for the table which is more meaningful. If you then wanted to produce a PT for the first time from this Table, then choose Summarize with Pivot Table In your case, where your PT has already been set upclick on any cell in your PTDeign tabChange Source give it the name of your Table. -- Regards Roger Govier "Fritz" wrote in message ... 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? __________ Information from ESET Smart Security, version of virus signature database 4814 (20100128) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4814 (20100128) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seeing what fields are showing in a Pivot Report | Excel Discussion (Misc queries) | |||
fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
Pivot Tables - Showing Details for some fields, but just summaries for others | Excel Worksheet Functions | |||
number of fields in the row fields in pivot table | Excel Discussion (Misc queries) |