conditional formatting and external data

hello,

I created a table with an external data link (sql) to the Excel sheet.
According to the information in the table I have defined the conditional formatting to many fields.
I fixed the implementation targets of the conditional format.

My problem is;

Every time I refresh the data sheet that I created in Excel, the conditional formatting that I create is changed in both the rule and application areas.

When I update the data, the conditional formatting rules and application areas are corrupted.

When I look at the settings in the data link and the conditional formatting field, I have not seen an option to fix this problem.

When I called Microsoft Turkey office, on the phone and directed staff could not help me in this field.

you can help me with what I should do.