Fix Excel Formulas Not Calculating in WPS Office Spreadsheets
Question details
The user needs to fix an Excel workbook in WPS Office Spreadsheets where formulas are not recalculating automatically.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user opened or edited an Excel workbook and noticed formula results do not update after changing input cells.
- Observed behavior
- Formula cells show stale results instead of recalculating; the workbook may be in manual calculation mode or contain a circular reference.
Open the affected workbook in WPS Office Spreadsheets and make sure the worksheet that contains the formulas is active. Keep the Formulas tab visible so you can quickly check calculation options and error checking.
Enable Automatic Calculation in WPS Office Spreadsheets
Use this when formula results do not update after changing values and the workbook is set to manual calculation mode.
By default, WPS Office Spreadsheets recalculates formulas automatically. If the workbook was opened from Excel with manual calculation enabled or changed by a macro, the setting may remain manual.
Open the affected workbook in WPS Office Spreadsheets and click the Formulas tab in the ribbon.
In the Calculation group, click Calculation Options.
Select Automatic from the drop-down list. WPS Office will recalculate existing formulas immediately.
Find and Remove Circular References
Use this when automatic calculation is enabled but formulas still show errors or do not update because a formula refers to its own cell.
Recalculate Excel Formulas Automatically with WPS Office Spreadsheets
WPS Office Spreadsheets lets you enable automatic calculation and check circular references in Excel-compatible workbooks, so formula results update without leaving your current workflow.
- 1. Open your workbook in WPS Office Spreadsheets: Launch WPS Office, click Open, and choose the Excel workbook that is not calculating.
- 2. Open Calculation Options: Go to the Formulas tab, click Calculation Options, and choose Automatic.
- 3. Run Error Checking for circular references: In the same tab, click Error Checking and select Circular References to resolve any listed cells.
- 4. Save and verify: Save the workbook as .xlsx or your original Excel format, then edit a sample input cell to confirm recalculation.
Frequently Asked Questions
Why is my Excel formula not updating in WPS Office Spreadsheets?
The workbook is likely set to manual calculation. Open the Formulas tab, click Calculation Options, and select Automatic to force recalculation.
How do I find a circular reference in WPS Office Spreadsheets?
Click Formulas, then Error Checking, and select Circular References. WPS Office lists or jumps to cells that refer to themselves so you can edit them.
Does switching to automatic calculation affect Excel files saved as .xlsx?
No. The setting applies to the workbook in WPS Office, and the saved .xlsx file remains compatible with Microsoft Excel.
What is the shortcut to recalculate formulas in WPS Office Spreadsheets?
Press F9 to recalculate all formulas, or press Shift+F9 to recalculate only the active worksheet after manual changes.
