View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
TC TC is offline
external usenet poster
 
Posts: 32
Default Dependent page items in pivot table

Thanks for the quick response.

"Jim Thomlinson" wrote:

Nope... All of the choices will dispay even though obviously some of them can
never be valid.
--
HTH...

Jim Thomlinson


"TC" wrote:

Is there a way to make page items in a pivot table dependent? For instance,
with page items of State and City, is there a way to limit City based on
State chosen?