Maintaining Destination Formatting on a Linked Excel Table

Written by Allen Wyatt (last updated December 26, 2020)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365


Kat has an Excel table in her Word document, pasted as "linked with destination formatting." She wants to control the formatting and borders within Word. If she sets the formatting of the borders and later uses F9 to update the linked data in the table, the borders revert to a simple grid. These borders do not match the borders drawn in Excel or the borders that Kat set in Word. She wonders if there is a way to make Word maintain the borders as she formatted them whenever she updates the data.

The behavior that Kat describes seems to be the way that Word works when you update linked Excel data. If you manually format the linked data, all your formatting is stripped when you update the data.

There is one way around the problem—use table styles. From testing, these do not seem to be removed during the update. You can find these styles by placing the insertion point inside the linked data (in your Word document) and then displaying the Table Design tab of the ribbon. You can use one of the pre-defined table styles, or you can create your own. (Right-click in the existing styles and choose New Table Style from the resulting Context menu.)

Once you've applied the table style (or created a new one and applied that), you can update your table and the formatting should remain as specified in the style.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (13815) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Importing Huge Data Files

Sometimes, when importing data created by other programs, you may find that there is too much for Excel to handle. Here's ...

Discover More

Using Custom Number Formats

Most formatting needs are met by using the predefined formatting options in Excel. The program also allows you to move ...

Discover More

WordTips: The Macros (Special Offer)

WordTips: The Macros can help you discover the power and capabilities of macros within the word environment. ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More WordTips (ribbon)

Embedding an Excel Chart in a Word Document

Word and Excel usually work pretty well together. This means that you can easily paste charts from Excel into your Word ...

Discover More

Embedding an Excel Worksheet

Word and Excel are both integral parts of Microsoft's Office suite of applications. As such, Word allows you to embed ...

Discover More

Creating Documents that Don't Use Embedded Fonts

Creating a PDF file from a Word document is easier than it used to be. Getting that PDF to contain exactly what you want ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is one more than 4?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Videos
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.