File Incompatibility

I have been using office 8 for some time now, and on the whole i find it good how ever calculates inability to open a XLS file drives me to the point of dispair and ruins the whole feel of the program to the point that i am now thinking of changing to libre office as it does not have any such limitations.