Excel Formatting overwritten on refresh

Dear all,

I am working with Analysis 1.4 with BEx Query in the backend.

After inserting the Bex query output, I change the column header (to appear in 2 lines instead of one) and center the columns. But on refresh, this formatting is overwritten.

Is there any way to retain these format changes?

Regards,

Abhishek Rajan.