There seems to be a strange bug related to Excel (I’m using 365) linked tables in Layout where certain cells in the linked table will not retain their layout formatting when the reference is updated.
I’m not 100% sure what causes it but it seems to be something to do with having an empty column before a data column with a merged title across the top of both columns. Example:
Column A Column B
Merged title across both A1 & B1
data in B2
data in B3
data in B4
data in B5
When this type of excel formatting is imported into a layout table and formatted the column B data points will not retain their layout formatting when the link is updated (import excel formatting is unchecked). Instead they seem to pick up the formatting of the cells in column A
Not a hard fix (change column A formatting) but still a bug you might want to look into.
If someone manages to recreate this issue I would like to know!
Edit: Updated to say formatting is coming from column A