Pivot Table Fields not showing

F

Fritz

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?
 
E

Eva

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
 
R

Roger Govier

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 tab>Table> 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 up>click on any cell in
your PT>Deign tab>Change Source> give it the name of your Table.

--
Regards
Roger Govier

Fritz said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top