Hi

you say
"Unless I am doing something wrong when I drag a field to the left column it
is supposed to put text in all of the cells underneath.
Sometimes there is no text underneath."
are you talking about when you have categories (in eg below the Cat & Dog
column and a sub-category, e.g. Size) ... the pivot table looks like this -

Cats......Small
..............Medium
..............Large
Dogs.....Small
..............Medium

this is the how it works.

your other questions:
1. If you hide a field how do you unhide it?
- just drag it from the field list onto the pivot table again
2. If you drag a field to the column the cells underneath should have text
inputted. I have to double-click on the field in the field window to make
the text underneath the cells appear.
- not really sure what you mean here ... the only thing i can think of
is do you have calculation set to manual (tools / options / calculations
tab) - this may have nothing to do with it but i can't say i've ever had to
double click on a pivot table to get text to appear.
3. Unless I am doing something wrong when I drag a field to column I don't
see the field or the contents.
- how is this different from 2. above?
4. How do I make the sum appear when I do want it?
- columns & rows are used for headings (e.g. the cat & dog & sizes in
the example above) - if you want a SUM of something you need to drag a
numeric field to the data area ... by default numbers will always ADD,
however, if the field that you drag to the data area is text then you will
get a COUNT.
5. What is this "data" field that appears out of nowhere?
- not sure what you mean by "appears out of nowhere" a pivot table
has four areas - page (an overall filter field), rows & columns for
categories and the data area for summing / counting / averaging of
information.

I hope this helps

Regards
JulieD

is this what you mwan
"Debutante" wrote in message
...
Thanks..sorry my boss walked by and I just hit "send" really fast never
finished the original e-mail.

Unless I am doing something wrong when I drag a field to the left column
it
is supposed to put text in all of the cells underneath.

Sometimes there is no text underneath.

1. If you hide a field how do you unhide it?
2. If you drag a field to the column the cells underneath
should have text inputted. I have to double-click on the
field in the field window to make the text underneath
the cells appear.
3. Unless I am doing something wrong when I drag a field to column I don't
see the field or the contents.
4. How do I make the sum appear when I do want it?
5. What is this "data" field that appears out of nowhere?

Thank you.