Users of Excel see its great potential and its intuitive interface and use it for things that builders of this product have not anticipated.
What's wrong here is that builders do not follow users and don't try to improve their product to better fit what the users are using it for. Excel should turn into actual database many years ago.
Personally I'd like to see Excel migrate in this direction: http://dabbledb.com/demo/#play