0

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?

0

There is a setting in PivotTable Field:

enter image description here

| improve this answer | |
  • 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 Jul 16 '19 at 12:28
  • I think this requirement cannot be achieved. Excel cannot record this action macro code. – Lee Jul 17 '19 at 1:47

Your Answer

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.