Pivot Table Questions

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

I have two questions about Pivot Tables.

1) When I double-click on a cell that has a value in it, I would like the
worksheet that it creates to list the information in alphabetical order
based on a given field automatically. How do I do this?

2) Is it possible to have the worksheet that is created upon double-click
to be created in a new workbook? If so, how?

Thaks,
Glenn
 
Back
Top