Forum Discussion
Column and colors Format do not save
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?
4 Replies
- Did you happen to save the workbook as a CSV?
Thanks Patrick2788 for your question. No, I usually save my work in xlsx, which is save automatically to this format.
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:
