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:
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.
Does anybody know if there is a registry hack or option in Excel that controls this behaviour?