When I connect to an OLAP data source in Excel and pivot, there are a list of dimensions and measure groups shown. These are expanded by default. Like below:

enter image description here

There is an option to "collapse all" under the Tools (cog icon) but I have to select it every time. I want it to look like below by default when i first connect.

enter image description here

Does anybody know if there is a registry hack or option in Excel that controls this behaviour?

New contributor
Dominic Cotton is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

There is a setting in PivotTable Field:

enter image description here

  • Thanks, however this isnt a setting it's an action and isn't permanent. I wanted this to default to collapsed whenever Excel is opened. – Dominic Cotton yesterday
  • I think this requirement cannot be achieved. Excel cannot record this action macro code. – Lee yesterday

Your Answer

Dominic Cotton is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.