Thanks. What I really wanted was dependent page fields in a pivot table but
Debra has answered in another posting that there is no setting to do what I
want to do.

I did try out the dependent validation lists however, and it worked great.
I'll have to see if I can come up with a different solution for my report.

Thank you.

"Marcelo" wrote:

Hi Maryc,

try the Debra tips at
http://www.contextures.com/xlDataVal02.html

hth
regards from Brazil
Marcelo



"MaryC" escreveu:

Is there a way to make the values available in one page field dropdown
dependent on the value selected in a second page field?