Hi,
Did this issue occurred with a particular file? Which type of formatting did lost? Generally speaking, If we are saving it in the older Excel 97-2003 format, then it is possible that the losses you are seeing are due to the formatting not being supported
in the older format. This is particularly true with colors and conditional formatting. Please try to save it as Excel 2013 format.
If this issue still exists, do you mind sending us a sample file? Email:
ibsofc@microsoft.com? So I can test it from my side. Please use thread link or the subject of this post as mail subject.
Regards,
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"