Pivot Table Questions

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Excel does not accept text format! 0
Pivot Table cell values 1
about pivot table 1
Need Help with Macro Security 1
Pivot table 0
Excel 2007 pivot table using analysis services cube as data source 0
Pivot Table Data Source 1

Top