How to Fix Excel Formulas Saving as Values or Numbers
Question details
The user's Excel formulas are converting into static numbers or values after the workbook is saved and reopened.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Saving a workbook containing active formulas such as VLOOKUP.
- Observed behavior
- Calculated formulas are stripped and replaced entirely by their static numerical values upon saving or reopening the file.
Before troubleshooting, verify the current file extension of your workbook (e.g., .csv, .xlsx) by checking the file properties or looking at the title bar in your spreadsheet software.
Save the Workbook in XLSX or XLSM Format
Prevent formulas from being discarded by saving your document in a modern spreadsheet format rather than plain text CSV.
The most common reason formulas are replaced with static values is saving the file in CSV (Comma Separated Values) format. CSV is a plain text format that only stores the displayed text of a cell, permanently discarding underlying formulas and formatting.
Click on the 'File' tab in the top-left corner of the ribbon, then select 'Save As'.
Click the 'Save as type' drop-down menu located below the file name input box.
Choose 'Excel Workbook (*.xlsx)' or 'Excel Macro-Enabled Workbook (*.xlsm)' from the list, then click 'Save'.

Correct Text and Number Format Mismatches
Ensure your lookup values and source data share the same data type so formulas calculate correctly instead of failing or returning static errors.
Use WPS Spreadsheet to Safely Manage and Save Complex Formulas
WPS Office fully supports modern Excel functions and natively saves in 100% compatible XLSX formats, ensuring your formulas are never lost or converted to static values during the save process.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing CSV or Excel document.
- 2. Access the Save options: Click on the 'Menu' button in the top-left corner and select 'Save As'.
- 3. Save as an Excel Workbook: Select 'Microsoft Excel Workbook (*.xlsx)' to guarantee all your active formulas are permanently preserved.

Frequently Asked Questions
Why do my formulas disappear when I close and reopen Excel?
You likely saved the file in CSV (Comma Separated Values) format. CSV is a text-only format that stores only the visible results in the cells, discarding all formulas, macros, and formatting when closed.
Does saving in the older XLS format affect my formulas?
Saving as an Excel 97-2003 Workbook (.xls) preserves standard formulas. However, if you use newer functions (like XLOOKUP) that are not supported in the older version, Excel may produce a compatibility warning and convert those specific unsupported formulas to static values.
How do I stop Excel from showing the formula text instead of the result?
If a cell displays the actual formula text (e.g., '=VLOOKUP(...)') instead of the calculated number, the cell is likely formatted as 'Text'. Right-click the cell, select 'Format Cells', change the category to 'General', and then double-click the cell and press Enter to recalculate.




