Remove expansion from Pivot table

[vipingarg23]

Hi Team,

I want to remove expansion sign from pivot table for some columns only(Dimensions). Can anyone help me?

Thanks.

[Anil_Babu_Samineni]

Can you explain little more?

[vipingarg23]

Hi..

There are around 8 column in my pivot table. I want starting two column as Always expanded but not all. For all We can do directly by clicking on always fully expanded but I want this feature only for two columns.

[Anil_Babu_Samineni]

There is no specific option to get into. But, If you like to go using macro yes there is work around. Will you? Here i think you must hit another object either button / text box.

[vipingarg23]

Yes..Sure...

[Anil_Babu_Samineni]

Normally, I don't prefer to use Macros and I would ask you to recommend / teach expand and collapse to USERs and then they came to know where we are doing and done this?

tamilarasu‌ please have a look on this thread using Macros?

[tamilarasu · Accepted solution]

Hi Vipin,

Instead of Macros, you can use bookmarks by enabling the option "Include Layout State". Create a bookmark for the levels of expansion you need (without any selections) and save it. After that apply the bookmark while activating the sheet through sheet activate trigger.

[vipingarg23]

Great...It worked....Thanks for your help.

[vishsaggi]

Hello Vipin,
Can you close the thread accordingly if you got the answer.

Thanks,

V.