OmniDocWhy Excel Spreadsheet Formatting Does Not Save
Excel formatting vanishes on save for a few common reasons, from wrong file types to read-only copies. Find your cause and fix it without starting over.
If you format a workbook, save it, and reopen it to find the colors, borders, and number formats back to plain, you have hit a problem that feels random. The numbers are usually still there, which makes it harder to tell what went wrong. When an Excel spreadsheet does not save formatting, the cause is almost always the file type, the file's read-only state, or a different program that re-saved it.
Each cause leaves a different trail. This guide helps you match your symptoms to a likely cause, confirm it, and apply a fix that does not depend on any single spreadsheet program. You will also learn habits that keep formatting intact after the next save.
Why does my Excel spreadsheet not save formatting? The short answer
In most cases, the file is being saved in a format or state that drops styles. Keep the workbook as .xlsx, make sure you can edit it, and save from a copy you control.
| Your situation | What to do | Why |
|---|---|---|
| You used Save As and picked CSV or plain text | Save again as an Excel Workbook (.xlsx) from your original file | CSV and text files store values only, not fonts, fills, or borders |
| The file came from an email, a download, or a preview | Enable editing, then save a copy under a new name | Read-only views block style changes from being written to the file |
| The file was opened in another spreadsheet app or a converter | Go back to your original .xlsx and redo the output | Other programs can rewrite or drop styles they handle differently |
| The file is an .xls or is in compatibility mode | Convert it to .xlsx and recheck conditional formatting | Older formats cannot store some newer formatting features |
Figure out which problem you have
Compare what you see with the table below. Several symptoms can appear together, so check each cause you suspect before you change anything.
| Symptom | Likely cause | How to confirm |
|---|---|---|
| Colors, borders, and fonts are gone, but the values are intact | The file was saved as CSV or plain text | Look at the end of the file name. If it reads .csv or .txt, this is the cause. |
| Changes look right until you reopen, then revert | The file was read-only or a preview copy, so edits never reached the disk | Check the message bar or title for a read-only notice, then try saving a copy under a new name. |
| Only some features are lost, such as conditional formatting or custom number formats | The file is an older .xls format or is in compatibility mode | Check whether the file name ends in .xls or the title bar mentions compatibility mode. |
| Formatting looks correct for you but wrong for a colleague | Another program or version re-saved the file, or they opened a converted copy | Ask which app they used and compare the file extensions of both copies. |
| Formatting reverts to an earlier state after you save | A sync tool restored an older version or created a conflict copy | Look for an extra copy with "conflict" in its name in the same folder. |
| The file will not open for editing, or says someone else has it | Another user has it open, or a stale lock file is holding it | Confirm no one else has the file open, close other copies, then reopen. |
Fix it step by step
Work through these steps in order. The first ones are quick checks, and the later ones take more time.
- Check the file extension. Look at the end of the file name. If it reads .csv or .txt, go back to your original workbook and save a new copy with Save As, choosing the Excel Workbook (.xlsx) type.
- Confirm the file is editable. If you opened it from an email, a download, or a preview, enable editing before you change any styles. If it sits on a shared or synced drive, copy it to a local folder first.
- Save a copy under a new name. Use Save As to create a working copy. Your original stays intact, and you can compare the two side by side.
- Check for compatibility mode. If the title bar or file name points to .xls or compatibility mode, convert the workbook to .xlsx and reopen it. Then recheck conditional formatting and custom number formats.
- Close other copies and check for conflicts. Make sure no one else has the file open. Look in the folder for conflict copies, keep the version that has your formatting, and delete the rest after you confirm.
- Stop round trips through converters. If you exported, uploaded, or converted the file, return to your original .xlsx and create the output again. Compare the new file against the original before you share it.
- Test on a sample. Copy the first five rows, with their styling, into a new workbook. Save, close, and reopen it. If the styling survives, apply the same fix to the full file.
If the workbook needs a translated version, you can upload the .xlsx on omnidoc.top. The output keeps the layout and tables, and you can choose bilingual or translation-only output. Check the translated file against your original before sharing, because machine translation can miss context in labels and notes. If you prefer to work on the file in a desktop app, OmniDoc's desktop client is available at download.omnidoc.top.
Prevent it next time
A few simple habits stop most formatting losses before they start.
- Keep one master copy in .xlsx and save working versions with Save As, so the master never gets overwritten by a converted file.
- Reopen the workbook once after saving and check a few styled cells, especially conditional formats and number formats.
- Store the workbook in one place, either a local folder or a single shared drive, so a sync tool does not create conflict copies.
- Build a clean template with your fonts, fills, and number formats, then start new files from it.
- Run files through converters or previews only when you need a specific output, and check the result each time.
❓ FAQ
1. Why did my Excel file lose its colors but keep the numbers?
The file was most likely saved as CSV or plain text, which store values only. Go back to your original workbook and save a new copy as .xlsx.
2. Does saving as .xlsx keep conditional formatting?
In ordinary workbooks, yes. If conditional formatting disappears, check whether the file was an older .xls format or was in compatibility mode, then convert it and recheck the rules.
3. Why does formatting show up on my computer but not on a colleague's?
Their copy may have been re-saved by another program or converted. Ask them to open the original .xlsx and compare file extensions with your copy.
4. Can I recover formatting after it was lost?
If your cloud storage keeps earlier versions, check its version history for a copy saved before the problem. If no earlier copy exists, reapply your styles on a working copy, using a template if you have one.
5. What should I check before using a free converter?
Look at file size limits, whether the tool adds watermarks, how it handles your data, and whether styles survive the conversion. Keep your original file either way, and compare the output before you rely on it.
📝 Summary
When an Excel spreadsheet does not save formatting, start by checking the file type, then whether the file is read-only or was re-saved by another tool. Keep an original .xlsx, work on a copy, and test each fix on a small sample before you apply it to the full workbook.
