Pivot Table Drilldown

  • Thread starter Thread starter CliffMc
  • Start date Start date
C

CliffMc

How can I limit the number of fields display, when I drill down on a Pivot
Table value.
 
Hi,

Excel always outputs all the fields. You will nead to delete the unwanted
columns after the drill down.
 
Hi,

Turn on the recorder and then do the drill down and then delete the unwanted
fields. Turn off the recorded. Test and post the code if there are problems.
 

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

Back
Top