Just as a follow up.

I went into SSMS and then analysis services.

I right clicked on the cube and went to browse. There was an error. I then right clicked and clicked on process. Once it finished processing, I was able to see the cube in excel.

So I learnt a little something of troubleshooting of Analysis services via SSMS.

Tony