Formats disappearing in Excel workbook shared in Teams
We are having issues with formats on a shared excel workbook in Teams. We create a new week by copying the previous one and pasting in a new tab. This worked fine for a while but now it loses all formatting - every font, colour, box - its very annoying! All the data is there including formulas but does anyone know how to stop this?
Brian Scott commented
I'm seeing this as well. One user added quite a few fills to various cells to indicate length of service. The fills showed in another user's team version. As soon as the user opened the sheet in Excel to edit it all of the fills disappeared from his version and the Team display.