File Format & Compatibility

How to Fix Excel Formulas Saving as Values or Numbers

Amos GikundaAmos Gikunda Nov 3, 2026 869 views

Question details

The user's Excel formulas are converting into static numbers or values after the workbook is saved and reopened.

How to Fix Excel Formulas Saving as Values or Numbers
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 you start

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.

Solution 1Recommended

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.

1
Access the Save As menu

Click on the 'File' tab in the top-left corner of the ribbon, then select 'Save As'.

2
Change the file type

Click the 'Save as type' drop-down menu located below the file name input box.

3
Select a modern Excel format

Choose 'Excel Workbook (*.xlsx)' or 'Excel Macro-Enabled Workbook (*.xlsm)' from the list, then click 'Save'.

Save the Workbook in XLSX or XLSM Format
Format Preserved: Saving in XLSX format ensures all your formulas, charts, and formatting are kept fully intact for the next time you open the workbook.
Seamless Formula Management

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing CSV or Excel document.
  2. 2. Access the Save options: Click on the 'Menu' button in the top-left corner and select 'Save As'.
  3. 3. Save as an Excel Workbook: Select 'Microsoft Excel Workbook (*.xlsx)' to guarantee all your active formulas are permanently preserved.
100% compatibility with Microsoft Excel XLSX, XLSM, and XLS formatsAdvanced formula auditing and error-checking toolsBuilt-in warnings when saving to formats that do not support formulasFree, lightweight, and features a familiar tabbed interface
microsoft office alternative - wps office

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.