Fix Excel Conditional Formatting Not Updating in Linked Word Table
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.

- 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.
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.
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.
Launch Microsoft Word and open the document containing the linked Excel table that is failing to update.
Locate the linked table in your document and right-click anywhere inside it to open the context menu.
Select 'Update Link' from the menu. Wait a moment for Word to communicate with Excel and refresh the data and formatting.
Recreate the Excel-to-Word Link
If updating the link fails to bring over the cell colors, the link might be corrupted or inserted using an unsupported format. Recreating it properly can resolve the issue.
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. Copy Spreadsheet Data: Open your data in WPS Spreadsheet, select the table with conditional formatting, and copy it.
- 2. Paste Special in WPS Writer: Open WPS Writer, navigate to the Home tab, click the Paste dropdown menu, and select Paste Special.
- 3. Insert as Linked Object: Choose 'Paste Link', select 'WPS Spreadsheet Object', and click OK to insert the dynamically linked table.

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.




