Libre Office clc file not opening in MSO Excel 2007

Hi,

I'm using Libre office 5.1, when i was send or share password protected or
more formulas included clc file to others that files are not opening in
Excel 2007(they dont have Libre office they are opening in MSO excel 2007).

At the time of file opening below error has occured.

   Untitled.jpg

If click yes later file will open but a lot of contents and formulas are
missing in that opened file.

How to fix this problem, pls help me

Regards,

Jinesh

From LO to which file format (ods, xls, xlsx) do you save the spreadsheet?
What is "clc file"?
Do the files open if no password is used?