How to copy automatically data from Excel file to Word file?

macropod · #1 10-25-2011, 04:11 AM

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).

fuchsd · #2 10-25-2011, 05:25 AM

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?)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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