always with all the collapsed dimensions

[lourdesfmt]

Hi,

Someone knows if there is an option to be able to configure that when opening a pivot table from the access point, this table is always with all the collapsed dimensions.

Some trigger, in the properties of the object or properties of the document.

I have read the properties of the pivot table in the reference manual but that option is not there.

[vishsaggi]

Check this box in presentation tab of your pivot table properties.

[neelamsaroha157]

As vishsaggi‌ said, uncheck the 'fully expanded' option and collapse all dimension one by one until first one and save it.

[lourdesfmt]

Hi Neelam,

I already have the option unchecked and if I collapsed each dimension and saved.

but at the moment the user navigates and expands the dimensions.

wants to re-enter the application are all collapsed in automatic.

[vishsaggi]

Did you try checking that option in presentation tab?

[lourdesfmt]

Yes

[vishsaggi]

So is it not working?

[lourdesfmt]

No, because I would like an option where I say that I always collapsed when I entered.

If I deactivate that option what it does is expand everything and that is not what I need.

[vishsaggi]

Not sure i understood your requirement. So when you get to that sheet where your pivot is available it should fully expand? Right ? Did not get you what you mean deactivate option it does expand everything and this not what i want?

[balabhaskarqlik]

May be add a macro, to make all dimensions expanded...

sub ExpandCollapseDimensions

set chart = ActiveDocument.GetSheetObject("CH21")

set gp = chart.GetProperties

gp.TableProperties.PivotAlwaysFullyExpanded = 'true'

chart.SetProperties gp

end sub