i have four page field drop down list on my pivot table and is there a
way in vb to have each list shorter becasue of what choice was made in
the preceeding list?