Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-03-2025, 07:17 AM
rclanger rclanger is offline Word table not updating when Excel source changed Windows 10 Word table not updating when Excel source changed Office 2019
Novice
Word table not updating when Excel source changed
 
Join Date: May 2019
Posts: 1
rclanger is on a distinguished road
Default Word table not updating when Excel source changed

I have a multi-column Excel table from which I copied two columns and pasted them into Word. My problem is that the Word table will not update when the source Excel table changes.



I have followed the directions from AI without positive results. I would have thought it would be easy.
Reply With Quote
  #2  
Old 04-03-2025, 12:42 PM
Charles Kenyon Charles Kenyon is offline Word table not updating when Excel source changed Windows 11 Word table not updating when Excel source changed Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,467
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Try selecting and pressing the F9 key (Fn+F9 on many computers).
If you need more help with this help us help you by telling us which steps you followed:
- to create the links, and
- to update them.
Reply With Quote
  #3  
Old 04-03-2025, 02:33 PM
macropod's Avatar
macropod macropod is offline Word table not updating when Excel source changed Windows 10 Word table not updating when Excel source changed Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,370
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

To ensure you have a table that updates when the Excel data update:
1. Copy the Excel range
2. In Word, choose Paste>Paste Special>Paste link, then choose your preferred paste format.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
RefreshAll data source Excel from Word As1900 Word VBA 0 08-31-2021 09:19 AM
Word table not updating when Excel source changed Keep formatting of linked Excel table when updating link in word eaddi Word 13 11-13-2015 11:11 AM
Word table not updating when Excel source changed Automatic word updating in table barnel Word Tables 2 06-07-2015 04:04 AM
Auto Updating and Using Excel as Source Shugs81 PowerPoint 0 02-21-2012 03:25 AM
Updating excel link alters table format in PP dbmagnus PowerPoint 0 06-03-2010 12:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft