Use Word Formula Fields with Merged Table Cells
Question details
The user needs to reference Word table data in a formula when the table contains merged cells or ERP-generated rows.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- A document contains a table with merged cells or data generated by an ERP system, and a formula needs to retrieve or sum table values.
- Observed behavior
- Formula fields or bookmarks may produce syntax errors, and fixed cell references do not automatically expand when rows change.
Check whether the data is in a native Word table or a linked Excel worksheet, since they use different referencing methods. Identify the target cells and check whether merged cells make their positions ambiguous.
Bookmark a Word table and reference a cell in a formula field
Use this method for a native Word table when you can identify a valid fixed cell address.
A bookmarked table reference applies to a Word table, not an embedded or linked Excel worksheet. Merged cells can make cell addresses unreliable or cause formula errors.
Click inside the Word table, then choose Table Layout > Select > Select Table.
Choose Insert > Bookmark, enter a name such as Tbl, and select Add.
Click where the result should appear. Press Ctrl+F9 on Windows or Cmd+F9 on macOS to insert field braces, then type =SUM(Tbl C3) between them. Do not type the braces yourself.
Right-click the field and choose Update Field. If it fails, check the bookmark and cell address, and test the formula in a table without merged cells.
When rows are added or regenerated, select the field and check that its C3 reference still points to the intended value; edit the field if necessary.

Link a specific Excel cell or range into Word
Use Paste Link when the source data is in Excel rather than a native Word table.
Edit Word-compatible documents with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for working with documents and spreadsheets. Open existing files to make migration easier, and check table layouts and formula fields after opening complex documents.

Frequently Asked Questions
Why does my Word table formula show a syntax error?
Merged cells can make table addresses difficult for Word to interpret. Check the bookmark and formula syntax, then test the reference in an unmerged table to isolate the cause.
Can I type the braces around a Word formula field?
No. Insert field braces with Ctrl+F9 on Windows or Cmd+F9 on macOS, then type the formula inside them. You can also use Insert > Quick Parts > Field where available.
Will a C3 reference include new rows automatically?
No. C3 is a fixed cell reference. After rows are added or ERP data is regenerated, check the field and adjust the reference if the intended value has moved.
Can a Word table bookmark reference a linked Excel cell?
No. For Excel data, select and copy the cell or range in Excel, then use Word's Home > Paste > Paste Special > Paste Link.




