Written by Allen Wyatt (last updated January 17, 2025)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and 2021
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 2021.
The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2019. Spend more time working and less time trying to figure it all out! Check out Word 2019 For Dummies today!
When you link parts of your document to other sources (such as an Excel workbook), you can make opening your document ...
Discover MoreWord and Excel usually work pretty well together. This means that you can easily paste charts from Excel into your Word ...
Discover MoreWord and Excel are both integral parts of Microsoft's Office suite of applications. As such, Word allows you to embed ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
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.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments