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
