Office Compatibility Issues

Fix Excel Incorrect Formula Reference Error When Opening a Workbook in WPS Office

Ayan MasoodAyan Masood Nov 13, 2026 869 views

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 you start

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.

Solution 1Recommended

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.

1
Confirm the recipient's Excel version

Ask the recipient to open Excel, go to File > Account, and note the version and build number, or check Help > About Excel.

2
Open the workbook in WPS Office and Excel

Open the same .xlsx workbook in WPS Office and in the recipient's Excel version to compare which references trigger the warning.

3
Review formulas with Find & Select

On the Home tab, click Find & Select > Find, search for '[' to find external workbook links, and inspect formulas that contain newer functions.

4
Check defined names and table references

Go to Formulas > Name Manager to review named ranges, and click any table to review structured references in table formulas.

5
Save as a compatible .xlsx file

In WPS Office, click Menu > Save As, choose Excel Workbook (*.xlsx), and save the file before reopening it in the recipient's version.

Compatibility reminder: If the workbook contains functions introduced in Microsoft 365, saving as .xlsx does not make older Excel versions support those functions.
Direct WPS Office solution

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. 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. 2. Review external references: Go to the Data tab and click Edit Links to inspect and update or break external workbook links.
  3. 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. 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.
Opens and saves Microsoft Excel .xlsx files without converting the workbook formatIncludes Find & Select, Name Manager, and external link tools to inspect reference errorsFree to use for viewing, editing, and repairing workbook referencesFamiliar spreadsheet interface reduces the learning curve when switching from ExcelMaintains compatibility with Excel formulas, tables, and defined names
microsoft office alternative - wps office

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.