#1
|
||||
|
||||
How to link data into excel inserted in word
Hello MSOfficeForums. I inserted Excel in Word to facilitate mathematical calculations. The data source is located in an excel workbook. Is there a way to link the excel that I inserted in Word with the data in the excel file so that any changes in the source book will be reflected in the word file? Thanks. |
#2
|
||||
|
||||
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] |
#3
|
||||
|
||||
Quote:
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. |
#4
|
||||
|
||||
If you name the Excel range before copying/pasting, the link will reflect any changes to the rows & columns spanned by that range name.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
||||
|
||||
I need to insert a row in Word then copy down the formula. Thank you!!!
|
#6
|
||||
|
||||
That suggests you're trying to copy individual cells and paste them into a table. Instead, simply copy the entire range in Excel and paste that into Word as a table.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
||||
|
||||
Post #2 meets my requirements better because the Excel table has more columns than the Word table. I tried vlookup but it seems Word does not recognize formulae.
|
#8
|
||||
|
||||
You still only need to copy & paste the columns required as a single entity. If there are intermediate columns you don't want, you should consider re-arranging the worksheet or creating a new one with just the ranges you're interested in from that worksheet, so the lot can be copied & pasted into Word as a single entity.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
||||
|
||||
I will try this. Again, thank you.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Inserted Pictures from Local Data to cells column in excel | jessicakencana | Excel Programming | 1 | 03-26-2016 03:51 AM |
MS Word and Excel Data Link | MDBeets | Word | 7 | 03-31-2014 02:23 PM |
Help Plz! Link Excel data to Word document | cory_0101 | Office | 1 | 09-27-2012 07:15 PM |
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 |