Hello All,
I am created a Pivot Table and when i dblclick on a Cell (which
contain Sum Value of Data) it display result in a new sheet with all
columns (which have original data).
now i want when i click on that cell it display result in new sheet
but limited columns (set by me)
is it possible if yes kindly help me.
Thanks in advance
Dev

Dev

Not possible through the UI, it will always display all columns in the
dataset

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(E-Mail Removed)DTHIS
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog


"Dev" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello All,
> I am created a Pivot Table and when i dblclick on a Cell (which
> contain Sum Value of Data) it display result in a new sheet with all
> columns (which have original data).
> now i want when i click on that cell it display result in new sheet
> but limited columns (set by me)
> is it possible if yes kindly help me.
> Thanks in advance
> Dev
>