This was very tricky but figured out eventually.
SharePoint 2010 and 2013, excel 2010.
Microsoft update KB3054886 will brake the ability to open excel documents with content type.
Just go to your installed updates remove "KB3054886" No need to restart computer just Explorer.
I hope this helps. It took me several hours to fix it and there are no other post online about this.
