Fix Excel Formulas Disappearing After Saving and Reopening a Workbook
Question details
User needs to keep Excel formulas and formatting after saving and reopening a workbook; the issue occurs when the workbook is saved in a text-based or unsupported format instead of an Excel workbook format.
- Product
- Microsoft Excel and WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user saves a workbook, closes it, and reopens it later to find formulas and formatting missing.
- Observed behavior
- Formulas and formatting disappear after reopening because the workbook was saved in a format such as CSV that does not preserve them.
Before saving the workbook, check the Save as type or default save format in File > Options > Save. If the file contains formulas, avoid CSV or TXT formats and confirm the target format is Excel Workbook (*.xlsx).
Change the Default Save Format to Excel Workbook (*.xlsx)
Use this solution to prevent Excel from saving workbooks in a text-based format by default and to keep formulas and formatting intact.
Excel may be configured to save new workbooks in a non-Excel format, especially if CSV was chosen previously. This change affects future saves; it cannot restore formulas already lost from a text-based file.
Launch Excel and select File > Options.
In the Excel Options window, click Save in the left menu.
Locate the Save files in this format drop-down list and select Excel Workbook (*.xlsx).
Click OK, then open or save the workbook again using File > Save or Save As so it is stored in the .xlsx format.
Use Save As to Save the Current Workbook as .xlsx
Use this solution when you only need to save one workbook in the correct format without changing Excel's default settings.
Recover or Rebuild Formulas When the Original .xlsx Is Missing
Use this solution if you no longer have the original .xlsx file and need to recover or recreate the formulas.
Save Workbooks as XLSX in WPS Office to Keep Formulas and Formatting
WPS Office Spreadsheets opens and saves Microsoft Excel .xlsx files directly, so you can change the file format and keep formulas, cell formatting, and layout without losing data.
- 1. Open the workbook in WPS Office: Launch WPS Office and open the workbook in WPS Spreadsheets. If the file is CSV or XLSX, it opens in the spreadsheet editor.
- 2. Open Save As: Click the Menu button in the top-left corner and choose File > Save As.
- 3. Choose Excel Workbook (.xlsx): In the Save as type drop-down, select Excel Workbook (*.xlsx) to preserve formulas and formatting.
- 4. Set location and save: Choose a save location and click Save. Close and reopen the new .xlsx file to verify formulas remain.
Frequently Asked Questions
Why do Excel formulas disappear after saving and reopening a workbook?
The workbook is usually saved in a non-Excel format such as CSV or TXT. These text-based formats store only values or text and strip formulas and formatting. Change the save format to Excel Workbook (*.xlsx) to preserve them.
Can I recover formulas after saving as CSV?
No. CSV files do not store formulas, only the displayed values. If you still have the original .xlsx file, open that instead. Otherwise, the formulas must be recreated.
How do I set Excel to always save as .xlsx?
Open Excel, select File > Options > Save, and set Save files in this format to Excel Workbook (*.xlsx). Click OK to apply the default save setting.
Does WPS Office save Excel files as .xlsx?
Yes. WPS Office Spreadsheets can open and save Excel .xlsx files while preserving formulas and formatting. Use Menu > File > Save As and select Excel Workbook (*.xlsx).
Does this issue mean my Office installation is expired or infected?
No. Formulas disappearing after saving is a file format issue, not a virus or an expired Office installation. Saving in the correct .xlsx format resolves the problem.
