Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-29-2019, 05:27 PM
macropod's Avatar
macropod macropod is offline How to link data into excel inserted in word Windows 7 64bit How to link data into excel inserted in word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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


Simply copy the Excel range and paste it into Word using Paste Special, with the 'paste link' option and your preferred paste format.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 03-29-2019, 06:10 PM
Marcia's Avatar
Marcia Marcia is offline How to link data into excel inserted in word Windows 7 32bit How to link data into excel inserted in word Office 2007
Expert
How to link data into excel inserted in word
 
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by macropod View Post
Simply copy the Excel range and paste it into Word using Paste Special, with the 'paste link' option and your preferred paste format.

Thank you Paul, the paste link option solved it. A problem arises when a row is inserted in the source data but I could happily work with that rather than the tedious encoding of hundreds of accounts every quarter of the year.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to link data into excel inserted in word Inserted Pictures from Local Data to cells column in excel jessicakencana Excel Programming 1 03-26-2016 03:51 AM
How to link data into excel inserted in word MS Word and Excel Data Link MDBeets Word 7 03-31-2014 02:23 PM
How to link data into excel inserted in word Help Plz! Link Excel data to Word document cory_0101 Office 1 09-27-2012 07:15 PM
How to link data into excel inserted in word How to dynamically link imbedded Excel chart with source data from Word TBoz Excel 1 07-06-2012 05:53 PM
Excel 07-Access 03 Data Link Issue ddw23 Excel 0 08-20-2010 09:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:48 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