We have used analyzing excel a lot and it have worked fine. But yesterday suddenly all the hierarchies have disappered. The fields are still visible but premaded hierarchies are not. I can still see ...
by chance, are you using both direct query and import modes on your model? we encountered this same issue with missing hierarchies (only in analyze in excel) when we added a direct query table to our existing data set (which were all set to Import Mode).