Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-2010, 10:35 AM
chandan56 chandan56 is offline Excel Link in word Windows XP Excel Link in word Office 2003
Novice
Excel Link in word
 
Join Date: Jun 2010
Posts: 1
chandan56 is on a distinguished road
Default Excel Link in word

I want to link the cells of a table with excel. Is it possible? From word help I find the following example to link. But it is not working.
"


{Link Excel.Sheet.1”C:\MYDocuments\Myexamples.xls””Sheet 1!R1C1:R4C4”\a\p}"

N.B. If I insert excel in a document, will it be possible to link with a excel sheet?
Reply With Quote
  #2  
Old 01-13-2011, 02:12 PM
atrivedi atrivedi is offline Excel Link in word Windows 7 Excel Link in word Office 2010 (Version 14.0)
Advanced Beginner
 
Join Date: Sep 2010
Posts: 37
atrivedi is on a distinguished road
Default Embed Excel Link in Word 2003

To Insert a linked object or embedded object from an Excel file into Word, please follow the instructions below.

1. Open both the Word document and the Excel worksheet that contains the data that you want to create a linked object or embedded object from.

2. Switch to Excel, and then select the entire worksheet, a range of cells, or the chart that you want.

3. Press CTRL+C to Copy.

4. Switch to the Word document, and then click where you want the information to appear.

5. On the Home tab, in the Clipboard group, click the arrow under Paste, and then click Paste Special.

6. In the As list, select Microsoft Office Excel object.

7. Click Paste to insert an embedded object, or click Paste link to insert a link to the object.

Hope this helps.

Reply With Quote
  #3  
Old 07-02-2015, 11:47 AM
MSUGOGRN4781 MSUGOGRN4781 is offline Excel Link in word Windows 7 64bit Excel Link in word Office 2007
Novice
 
Join Date: Jul 2015
Posts: 1
MSUGOGRN4781 is on a distinguished road
Default

Apologies to be re-opening this thread after such a long time but I do have a similar but not the same issue. My company is currently using software (made by Rivet) that creates a link between Excel and Word. However, when we insert the linked tables in word, they are created as Word Tables versus pictures (what happens when you paste special). What this means is that we can run a redline from the prior document and if any numbers have changed in the table, only those changes will be redlined. This is as opposed to a linked table in word which will simply identify that a change was made to the table, delete the picture of the table, and then add the new one.

Does anybody know if this is possible in Word to do the same thing or any other software options like this?

Thanks!
Reply With Quote
  #4  
Old 07-02-2015, 07:07 PM
macropod's Avatar
macropod macropod is offline Excel Link in word Windows 7 64bit Excel Link in word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,213
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

When you paste an Excel link in Word, the paste Special dropdown gives you a number of paste format options. Simply choose the paste format that best suits your needs.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating excel link alters table format in PP dbmagnus PowerPoint 0 06-03-2010 12:12 PM
Need help in format or link in excel handsome1968 Excel 1 05-01-2010 09:20 AM
Excel Link in word Paste Excel Link As tphillippe PowerPoint 1 11-26-2009 05:54 PM
Excel Link in word independent hyper link execl & word tambal Excel 1 05-20-2009 03:07 PM
Link Bar Duplication redbull2689 Misc 0 06-11-2006 08:39 PM

Other Forums: Access Forums - Senior Forums

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


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