Fix Excel Incorrect Formula Reference Error When Opening a Workbook in WPS Office
Question details
User needs to troubleshoot Excel warnings about incorrect table, formula, name, or external-link references that appear only when the workbook is opened on another computer.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A workbook created or edited in one version of Excel or WPS Office is shared with another user, and reference warnings appear only on the recipient's computer.
- Observed behavior
- Excel shows incorrect table, formula, name, or external-link reference warnings when opening the workbook, but the workbook may behave correctly on the original computer.
Before troubleshooting, confirm the Excel version or WPS Office version on both the original computer and the recipient's computer, and make a copy of the workbook for testing.
Check Excel versions and review newer functions, names, tables, and external links
Use this first when a workbook shows formula reference warnings only on another computer; it isolates version and feature incompatibilities.
Excel and WPS Office use different compatibility levels for dynamic arrays, defined names, structured table references, and external links. A warning that appears only on another computer usually points to a feature that the recipient's version cannot resolve.
Ask the recipient to open Excel, go to File > Account, and note the version and build number, or check Help > About Excel.
Open the same .xlsx workbook in WPS Office and in the recipient's Excel version to compare which references trigger the warning.
On the Home tab, click Find & Select > Find, search for '[' to find external workbook links, and inspect formulas that contain newer functions.
Go to Formulas > Name Manager to review named ranges, and click any table to review structured references in table formulas.
In WPS Office, click Menu > Save As, choose Excel Workbook (*.xlsx), and save the file before reopening it in the recipient's version.
Search for external links and repair workbook references
Use this when warnings indicate external-link or name reference issues; it cleans unresolved links before you share the workbook again.
Troubleshoot Excel Formula Reference Warnings Directly in WPS Office
Open the problematic workbook in WPS Office, review formulas and external links, repair or remove unresolved references, and save the file as a fully compatible .xlsx workbook before sharing it again.
- 1. Open the workbook in WPS Office: Launch WPS Office, click Open, and select the .xlsx workbook that triggers the incorrect formula reference warning.
- 2. Review external references: Go to the Data tab and click Edit Links to inspect and update or break external workbook links.
- 3. Check formulas and names: Use Home > Find & Select > Find to search for '[' and open Formulas > Name Manager to review defined names and table references.
- 4. Save as a compatible workbook: Click Menu > Save As, choose Excel Workbook (*.xlsx), and save the file before reopening it in the recipient's Excel version.

Frequently Asked Questions
Why does Excel show an incorrect formula reference only on another computer?
It usually happens because the recipient's Excel version does not support newer functions or dynamic array formulas, or because external links and defined names are not available on that computer. Check the Excel version and review the workbook's formulas with Find & Select and Name Manager.
Can WPS Office open and repair an Excel workbook with external link warnings?
Yes. Open the workbook in WPS Office, go to Data > Edit Links to update or break external links, then use Formulas > Name Manager to fix invalid names and save the file as a .xlsx workbook.
Will saving an Excel workbook as .xlsx fix formula reference errors?
Saving as .xlsx helps standardize the file format, but it does not make older Excel versions support newer functions such as FILTER or XLOOKUP. You still need to replace or avoid those functions in older Excel versions.
How do I find external references in an Excel workbook?
In WPS Office or Excel, go to Home > Find & Select > Find, and search for the left square bracket '['. This locates formulas that point to other workbooks so you can update or remove them.
What should I check before sharing a workbook to avoid reference errors?
Use Data > Edit Links, Formulas > Name Manager, and a search for '[' to review external links, named ranges, table formulas, and dynamic array functions, then save the workbook as an .xlsx file and confirm the recipient's Excel version.




