Unless you are using code, creating the pivot table with the Layout button,
in the pivot table wizard, is the easiest method I have found.

Right click on the created pivot table, select the Pivot Table dropdown, and
select Wizard. Select Back. Make sure the pivot table data range is correct.
Make sure every column of data used in the pivot table has a header at the
top of it and is included in the pivot table data range. Click Next. Click
Layout and make sure the fields are in the correct location on the pivot
table. Click on OK. Click Finish. Right click each field, check the field
settings for each one, and make sure they are set to your specifications
(Sum, Count, etc...).

The data in the Data field must be numeric, except for the header, unless
you are doing a count of text (names, states, etc...).

Typically a pivot table is in a separate location from the data. You can not
alter it since it is sort of like a picture of the data in the range used
for the pivot table. You need to modify the data in the range then refresh
the pivot table. If you are replacing the data with a pivot table, you
should be able to edit the table itself. Creating a pivot table in this way
does replace the existing data.

Regards,

Alan


"Michelle" wrote in message
...
I am unable to display the list of fields when creating Pivot Tables. The
only way I've found to set the table up is to click on the 'Layout' button
in
Step 3 of the Pivot Table Wizard. At that point I have what I need for
the
moment but I am unable to alter/edit the table.