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.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"CliffMc" wrote:

Would anyone have some VBA that would do that for me?

"Shane Devenshire" wrote:

Hi,

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"CliffMc" wrote:

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