Formatting gets lost

[Kaso]

Hi,

i noticed a problem that is only appearing in Excel 365 for me.

My result table from PQ has numbers and dates and the formatting is expanded for each new row perfectly in Excel 2013 and 2016.
However if i open it with Excel 365 it does the formatting on the first row, but does every other row with the format "standard" after that and i have no idea why.
I'll add a simple example and 2 pictures for everyone to see what i'm talking about, realy hope someone can help me with this.

(I know about the "keep sort/filter/layout option but that isnt working because most of my columns get renamed each time i open my template, depending on the given date, as shown in the example).
View attachment Example.xlsx

 

[Ken Puls]

Hi Kaso,

Sorry for the late reply on this. I can't repro your issue using the Office 365 insider's build. All the formatting works properly.

One thing to check though... go to the Table Tools -> Design tab --> Properties. Ensure that the Preserve cell formatting setting is OFF. That holds formatting from previous settings and doesn't let the Power Query settings get reapplied.