Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2011, 07:57 AM
KIM SOLIS KIM SOLIS is offline Is it possible to link an Excel File to a Word table? Windows XP Is it possible to link an Excel File to a Word table? Office 97
Novice
Is it possible to link an Excel File to a Word table?
 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default Is it possible to link an Excel File to a Word table?

Hi all,



In the MS Word (file name MyWord, page1) I made a Table with five rows, say with three columns as Data1, Data2 and Data3. Now, in my Excel file (file name MyExcel.xls, sheet1) I also have three columns as File1, File2 and File3. My excel file is currently populated with records up to five rows.

My question is: Is it possible for my data in Excel to be dynamically and automatically exported to the MyWord.doc file, where my File1 data goes to the Word table Data1, and so on?...and eventually fill in all the five rows in Word.

My verdict thus far is, it is not legit. But will be extremely glad to be proven wrong .

Kim
Reply With Quote
  #2  
Old 09-07-2011, 08:00 AM
OTPM OTPM is offline Is it possible to link an Excel File to a Word table? Windows 7 32bit Is it possible to link an Excel File to a Word table? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Kim
You can embed an excel table in MS Word and open it from Word as if you were in Excel.
Select Insert -> Object -> From File -> Browse and select Workbook. It will ask you which sheet you wish to insert.
Once inserted just double click on the excel table and it will open in MS Word as if you were in Excel.
Good luck.
Tony(OTPM)
Reply With Quote
  #3  
Old 09-07-2011, 08:10 AM
Catalin.B Catalin.B is offline Is it possible to link an Excel File to a Word table? Windows Vista Is it possible to link an Excel File to a Word table? Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

of course it is possible, it is as simple as your previous post...
just select your table, and in word document, choose from paste special-excel object
or paste with link, as in samples attached (i guess you are familiar with the sample table.. )
Attached Files
File Type: docx test excel table.docx (26.8 KB, 19 views)
File Type: xlsx Query101.xlsx (11.4 KB, 16 views)
Reply With Quote
  #4  
Old 09-07-2011, 08:33 AM
KIM SOLIS KIM SOLIS is offline Is it possible to link an Excel File to a Word table? Windows XP Is it possible to link an Excel File to a Word table? Office 97
Novice
Is it possible to link an Excel File to a Word table?
 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default

Hi Tony,

I understand I had two ways to do it:
1) Create first a Table in word and format table with three columns and five rows, and then manually encode what my Excel data shows, or
2) Create table in Word by directly embedding the existing file from Excel.

I tried option 2 per your advice and I am getting mixed result. One file I embedded (with data entries up to 18 rows displayed only up to ten rows), though I repeated several times. Meaning that all my Excel data did not show up in the embedded table. I tried another file and lo, the embedded file displayed all rows and columns. Is there a control to what extent of table (rows and column) can be embedded?

Nevertheless, I noticed that when the Excel is embedded in Word, THEN I APPENDED OR EDITED MY DATA IN EXCEL, my data in word does not change but is static. Is there a way to make it dynamic? That as I change data in Excel so it must be auto-reflected in Word. But that looks not possible using the embedding option.

It will be nice if the "linking" - from Excel to Word - will be dynamic and data changes are reflected in "real-time".

Will hear your feedback then.

Waiting,

Kim
Reply With Quote
  #5  
Old 09-07-2011, 08:58 AM
OTPM OTPM is offline Is it possible to link an Excel File to a Word table? Windows 7 32bit Is it possible to link an Excel File to a Word table? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Kim
The problem is how big do you want the table to be in Word!!!!
What you could do is create an Auto Macro which runs as soon as you open MS Word which will copy the current table as it stands.
Would this give you what you want?
Tony(OTPM)
Reply With Quote
  #6  
Old 09-07-2011, 09:03 AM
OTPM OTPM is offline Is it possible to link an Excel File to a Word table? Windows 7 32bit Is it possible to link an Excel File to a Word table? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Kim

I have just fouynd a similar post on another Forum from Paul Edstein an MS Word MVP who provides a possible solution. Try his link:@

http://www.mrexcel.com/forum/showthread.php?t=335522

Come back to the forum if you are still struggling.

Tony(OTPM)
Reply With Quote
  #7  
Old 09-07-2011, 09:20 AM
KIM SOLIS KIM SOLIS is offline Is it possible to link an Excel File to a Word table? Windows XP Is it possible to link an Excel File to a Word table? Office 97
Novice
Is it possible to link an Excel File to a Word table?
 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default

Thanks Tony,

Wow! The dynamic link sounds possible and legit after all . The table in Word is just about five to eight columns maximum, though the rows may vary depending on the data population.

To give you an idea, here's why I need this dynamic link to work. There is already a standard company-wide pre-formatted report in Word, complete with Tables, spaces for Images and the usual narrative report. The requirement is just to populate the tables based on the Excel data which changes every quarter. There is about 40 tables at hand to be updated regularly.

Thus, if a DYNAMIC link from Excel to Word is truly possible then your idea that as I open the Word so will the data auto-refresh itself is brilliant next to none.

To answer your last note, indeed, it will give me more than I can bargain for.

Best regards,

Kim
Reply With Quote
  #8  
Old 09-08-2011, 01:26 AM
OTPM OTPM is offline Is it possible to link an Excel File to a Word table? Windows 7 32bit Is it possible to link an Excel File to a Word table? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Kim
If your standard word document is not confidential can you let me have a copy and I will see how it can be set up to pick up Excel tables Automatically (you can send it to otpm@blueyonder.co.uk if that is acceptable or failing that just give me a sample Word Document of the format to work from.
Tony(OTPM).
Reply With Quote
  #9  
Old 09-08-2011, 06:11 AM
macropod's Avatar
macropod macropod is offline Is it possible to link an Excel File to a Word table? Windows 7 64bit Is it possible to link an Excel File to a Word table? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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 Kim,
Quote:
Originally Posted by KIM SOLIS View Post
The table in Word is just about five to eight columns maximum, though the rows may vary depending on the data population.
In that case, provided you set up the LINK field as described in the link Tony posted, all you will need to do for changes to the # or rows is to change the range in Excel to which the named range referred to in the LINK field applies.

You also mention the need for this to be used in:
Quote:
a standard company-wide pre-formatted report
Do note that the paths in Word's LINK fields are absolute. If you move the Excel file, you'll need to change the link path in Word (eg via Edit|Links). Likewise if you provide the 'automated' report to others for their use - they'll need to change the links to point to their own Excel workbooks (and the named ranges within).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #10  
Old 09-08-2011, 07:05 AM
KIM SOLIS KIM SOLIS is offline Is it possible to link an Excel File to a Word table? Windows XP Is it possible to link an Excel File to a Word table? Office 97
Novice
Is it possible to link an Excel File to a Word table?
 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default

Hi Tony,

Thanks again for the reply. I will email the data as adviced for your further evaluation. On second thoughts, and taking hint from Paul's note, if my desired output appears ideal yet complicated then I am open to a more practical approach, other than making the dynamic link option, to yet accomplish the auto-updating of the pre-formatted report in Word.

Let's give it time. I will consolidate files from my end and email you in time. Not really that urgent to make it soon. What I am getting now, of which I am confident of your assessment is that it is indeed possible, and so I will now consider this query solved ... and my pre-forum verdict as mere speculative at best.

...just can't wait. Ha ha ha. I just sent you today the pre-formatted .doc report for your evaluation. You are free to email Paul it that suits well too.

Cheers then and thanks. Will keep in touch.

Kim
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to link an Excel File to a Word table? Excel Link in word chandan56 Office 3 07-02-2015 07:07 PM
Is it possible to link an Excel File to a Word table? Excel data to Word table Jaymond Flurrie Word VBA 2 02-27-2011 07:42 PM
link comment to a pivot table dom585 Excel 0 07-15-2010 11:11 AM
Updating excel link alters table format in PP dbmagnus PowerPoint 0 06-03-2010 12:12 PM
Is it possible to link an Excel File to a Word table? Problem creating link to image file leftylee PowerPoint 1 04-14-2010 05:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:53 AM.


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