Hi all,

So I have this workbook with 6-7 sheets.

Each page has loads of formatting, cell formatting, fill colors, borders, that sort of thing.

It all looks good but no matter what I do, every time I save it and re-open it, all the formatting is gone and the cells have reverted back to plain text.

I've done some searching but I can't find anything. I even recreated the whole workbook and it did the same thing.