Overview
You can't force yourself to get along better with someone if they won't cooperate -- either you two are compatible or you're not compatible. So instead of continuing to beat your head against the wall trying to charm them, accept the situation as it is and make the best of it. You do not have to make everyone your friend. And try to understand that just because someone doesn't light up when you walk into a room doesn't mean that they don't respect you.