Why Word Linked Excel Table Loses Formatting When Source Refreshes

You have a table in Word linked to an Excel source. Every time you refresh the link, the table loses its custom formatting. Borders, font sizes, cell shading, and column widths all revert to the default Excel appearance. This happens because Word treats the linked data as a pure data paste and discards local formatting when the link updates. This article explains why the formatting resets and provides three reliable methods to preserve your table design.

Why Word Linked Excel Table Loses Formatting on Refresh

When you link an Excel table into Word, the two programs handle formatting differently. Excel stores cell-level formatting like borders, fill colors, and number formats inside its own file. Word, on the other hand, stores the linked data as a field code — a reference — not as a native Word table. When the link refreshes, Word pulls the raw values from the Excel source and rebuilds the table using the default Word table style. Any manual formatting you applied in Word is overwritten because the field code does not retain those local changes.

The underlying mechanism is the OLE (Object Linking and Embedding) link. An OLE link stores only the source file path and a reference to the cell range. It does not store formatting instructions. When you update the link, Word re-reads the range and applies the default table style. If you applied custom borders, merged cells, or specific column widths in Word, those get lost.

Paste Options That Affect Formatting

The method you use to paste the Excel table determines whether formatting is preserved. The default Paste Link option (Use Destination Styles) discards Excel formatting and applies the Word default. The alternative Paste Link option (Keep Source Formatting) tries to retain Excel formatting, but local Word overrides still reset on refresh. Only the Embed option or pasting as a picture prevents formatting loss, but each has trade-offs.

How to Paste an Excel Table Link With Formatting That Stays

To keep formatting when the source refreshes, you must use a paste method that stores formatting data inside the Word document. Below are three methods. Choose the one that fits your need for editability versus formatting stability.

Method 1: Paste Link Using Keep Source Formatting

1. Copy the Excel range
   In Excel, select the table cells. Press Ctrl+C.
2. Switch to Word and open Paste Special
   Place the cursor where you want the table. On the Home tab, click the arrow under Paste and select Paste Special.
3. Select Paste link and Microsoft Excel Worksheet Object
   In the Paste Special dialog, click Paste link. In the list, choose Microsoft Excel Worksheet Object. Click OK.
4. Format the table in Excel before linking
   All formatting — fonts, borders, fills, column widths — must be set in Excel before you copy. After the link is created, do not format the table in Word. When the link refreshes, the Excel formatting will return.

This method preserves Excel formatting across refreshes, but you cannot apply Word-specific formatting to the table cells. Any Word formatting you add will be lost on the next update.

Method 2: Paste as a Picture

1. Copy the Excel range
   In Excel, select the table cells. Press Ctrl+C.
2. In Word, open Paste Special
   Place the cursor. On the Home tab, click the arrow under Paste and select Paste Special.
3. Choose Picture (Enhanced Metafile)
   In the Paste Special dialog, do not select Paste link. Select Paste. In the list, choose Picture (Enhanced Metafile). Click OK.
4. Update the picture when data changes
   When the Excel source changes, you must re-copy the range and re-paste as a picture. The picture does not update automatically.

This method freezes the exact visual appearance. Formatting never resets because it is a static image. The downside is that the data is not editable inside Word and does not refresh automatically.

Method 3: Embed the Excel Object

1. Copy the Excel range
   In Excel, select the table cells. Press Ctrl+C.
2. In Word, open Paste Special
   Place the cursor. On the Home tab, click the arrow under Paste and select Paste Special.
3. Select Paste and Microsoft Excel Worksheet Object
   In the Paste Special dialog, make sure Paste is selected (not Paste link). Choose Microsoft Excel Worksheet Object. Click OK.
4. Edit the embedded object
   Double-click the table in Word to open the embedded Excel worksheet. Make changes there. The formatting stays with the embedded file.

An embedded object stores a copy of the Excel file inside the Word document. Formatting is preserved because the data and its formatting are part of the embedded file. The trade-off is that the file size increases, and you have two copies of the data to manage.

Common Issues With Linked Excel Tables in Word

Linked table shows #REF! or #VALUE! errors after refresh

If the Excel source file is moved, renamed, or deleted, the link breaks. Word cannot find the source and displays error values. To fix this, go to File > Info > Edit Links to Files. Click the broken link, then click Change Source to point to the correct Excel file.

Word freezes when updating a large linked table

A linked table with hundreds of rows can cause Word to become unresponsive during refresh. To reduce this, limit the linked range to only the rows and columns you need. Alternatively, paste as a picture to remove the live link entirely.

Column widths reset after refresh

Column widths are part of the Excel formatting. If you set column widths in Word, they are overwritten when the link refreshes. Set the column widths in Excel before creating the link. In the Paste Link dialog, choose Keep Source Formatting to retain those widths.

Paste Methods for Excel Tables in Word: Formatting Behavior Comparison

Item	Paste Link (Use Destination Styles)	Paste Link (Keep Source Formatting)	Paste as Picture
Automatic refresh	Yes	Yes	No
Formatting survives refresh	No	Yes (Excel formatting only)	Yes (static image)
Editable in Word	Yes	Yes	No
File size impact	Small	Small	Medium

You now know why linked Excel tables lose formatting and which paste method prevents it. For automatic updates with Excel formatting, use Paste Link with Keep Source Formatting. For a static snapshot that never changes, paste as a picture. For full editability with formatting, embed the object. To further protect your layout, set all column widths and cell styles in Excel before creating the link.