View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Leonardo
 
Posts: n/a
Default How do i create multiple pivot tables with one field automatically

I'm trying to get a sheet for every single element of a field in a pivot table.
I know this is possible by double clicking in the field once it's located at
the top of the pivot table. But i haven't been able to do it now and i was
wondering if there's a certain option i should flag or unflagged.

Thank you.