Mar 03 2023 10:04 AM
I have imported data into a spreadsheet, formatted columns width, added colored text, saved it before closing it, and all formatting disappeared (back to the original) when I open it again next day. Never done that before. What am I missing?
Mar 03 2023 10:43 AM
Mar 03 2023 11:05 AM
Thanks @Patrick2788 for your question. No, I usually save my work in xlsx, which is save automatically to this format.
Mar 03 2023 11:24 AM
A loss of that much formatting is often preceded with Excel attempting to repair the workbook on open. That would suggest the workbook has an exorbitant number of cells styles and/or is very large.
A workbook starts with 47 styles. If a workbook is generated from outside of MS Office, it's possible it can come loaded with thousands of cell styles (about 65K is the limit).
This is the default 47:
Mar 03 2023 11:43 AM