Have you got missing cubes in your Excel Data Connection Wizard?
A customer noticed this yesterday and had spent all afternoon looking for the issue, rebuilding, deploying, processing, deleting and recreating on the server etc. all to no avail. He even checked the role permissions and anything usual.
The issue is not the CUBE but the MEASUREs in the cube.
Check the Measures VISIBLE property is not set to FALSE.
In his case it was and that’s why it was not showing. It is not publicised very well on the net so I thought I would stick this post up to help this.
Open the Cube
In the Cube Structure window locate the Measures and select it.
In the Properties you will see a Visible property
Set it to True
Note that you will be able to see the cube in Management Studio but not in Excel.