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?

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?

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