File Format & Compatibility

Fix Excel Conditional Formatting Not Updating in Linked Word Table

Huma Ashraf ChHuma Ashraf Ch Oct 28, 2026 869 views

Question details

The user needs to resolve an issue where cell colors generated by Excel conditional formatting do not refresh in a linked Word table, even though the numerical data updates correctly.

How to Fix Excel Conditional Formatting Not Updating in a Linked Word Table
Product
Microsoft Word and Excel
Device & OS
not provided
Scenario
Updating a Word document that contains a linked table from an Excel spreadsheet with conditional formatting applied.
Observed behavior
Numerical data updates successfully in the Word table, but the conditional formatting (cell colors) from Excel fails to reflect the dynamically calculated changes.
Before you start

Ensure both your Word document and the source Excel workbook are saved and accessible on your local drive before attempting to refresh or recreate the links.

Solution 1Recommended

Manually Update the Link in Word

Force Word to fetch the latest formatting and data from the linked Excel file.

Often, Word only pulls the raw text data automatically to save processing resources. Manually triggering a link update forces the application to refresh the OLE object completely, bringing in the latest conditional formatting colors.

1
Open the Word Document

Launch Microsoft Word and open the document containing the linked Excel table that is failing to update.

2
Right-click the Table

Locate the linked table in your document and right-click anywhere inside it to open the context menu.

3
Update Link

Select 'Update Link' from the menu. Wait a moment for Word to communicate with Excel and refresh the data and formatting.

Refresh Limitations: Depending on the size of the Excel file, the update process may take a few moments. Do not click away until the cursor returns to normal.
Seamlessly Link Data

Link Spreadsheet Data to Documents Reliably in WPS Office

WPS Office allows you to easily link spreadsheet data and formatting into your documents. With WPS Writer and WPS Spreadsheet, your conditional formatting and data updates stay perfectly synchronized.

  1. 1. Copy Spreadsheet Data: Open your data in WPS Spreadsheet, select the table with conditional formatting, and copy it.
  2. 2. Paste Special in WPS Writer: Open WPS Writer, navigate to the Home tab, click the Paste dropdown menu, and select Paste Special.
  3. 3. Insert as Linked Object: Choose 'Paste Link', select 'WPS Spreadsheet Object', and click OK to insert the dynamically linked table.
Retain conditional formatting and cell colors when linking tablesFully compatible with Microsoft Excel (.xlsx) and Word (.docx) filesUpdate linked data instantly with a single clickFree, lightweight, and easy to use across all your devices
microsoft office alternative - wps office

Frequently Asked Questions

Why do numbers update but not the cell colors in a linked Word table?

This usually happens because Word sometimes only refreshes the raw text data to save processing resources. Conditional formatting relies on Excel's calculation engine, requiring a full OLE object update to render the new colors correctly.

Can I link Excel conditional formatting to Word without using OLE objects?

No, if you paste the table as standard HTML or formatted text, the link will only carry over the data and basic static formatting. To maintain dynamic conditional formatting, you must paste the table as a linked Excel Worksheet Object.

How do I force all linked tables in my Word document to update at once?

You can update all links in a document simultaneously by pressing Ctrl + A to select the entire document, and then pressing the F9 key. This will prompt Word to refresh all linked objects and fields.

What should I do if 'Update Link' is grayed out in Word?

If 'Update Link' is grayed out, the table was likely pasted as static text or an image rather than a linked object. You will need to delete the table, return to your Excel file, copy the data again, and use 'Paste Special > Paste Link' in Word to establish a proper connection.