Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-25-2011, 04:11 AM
macropod's Avatar
macropod macropod is offline How to copy automatically data from Excel file to Word file? Windows 7 64bit How to copy automatically data from Excel file to Word file? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
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

Hi fuchsd,



You can create a link between Excel and Word by selecting a range in Excel, copying it, then activating the Word document, selecting the destination and choosing Edit|Paste Special, checking the 'paste link' option and choosing the paste format you desire. From then on, any change to the Excel data should be reflected in Word (you may need to go to Tools|Options|General and make sure the 'Update automatic links at open' option is checked).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 10-25-2011, 05:25 AM
fuchsd fuchsd is offline How to copy automatically data from Excel file to Word file? Windows XP How to copy automatically data from Excel file to Word file? Office 2000
Novice
How to copy automatically data from Excel file to Word file?
 
Join Date: Oct 2011
Posts: 4
fuchsd is on a distinguished road
Red face :)

that's the one!
thank you so much for your help.
Is there any chance to update automatically link during file editing ? (without another re-open the file and not F9 key?)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to restore original data format - from a .pdf file to Excel columns KIM SOLIS Excel 1 09-18-2011 10:49 PM
Can Word automatically do "Finish and Merge" after opening file? DaveBF Mail Merge 1 09-14-2011 07:56 AM
Help! Find text in doc file & copy to another file northstarman Word 1 11-05-2010 08:15 AM
Excel file lost data how to recover it zillah Excel 1 02-10-2010 08:36 PM
copy a file which does not have copy option jkind Word 0 01-17-2010 09:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:04 PM.


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