Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-02-2014, 08:11 AM
lucky16 lucky16 is offline How to Link an excel cell to word using Quickparts? Windows 7 32bit How to Link an excel cell to word using Quickparts? Office 2007
Novice
How to Link an excel cell to word using Quickparts?
 
Join Date: Jan 2014
Posts: 21
lucky16 is on a distinguished road
Default How to Link an excel cell to word using Quickparts?

Hello,

I am trying to link an excel cell to a macro enabled word document. I tried using paste special option, but for some reason the update field option does appear when i close and re open the document. I'm guessing there would be other ways to link an excel cell to word. Could this be possible with quick parts in word.

Thank You!
Have a Nice Day.
Reply With Quote
  #2  
Old 10-02-2014, 02:38 PM
macropod's Avatar
macropod macropod is offline How to Link an excel cell to word using Quickparts? Windows 7 64bit How to Link an excel cell to word using Quickparts? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
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

Are you creating the link in code, or manually? If you're using code, please post that portion (using the code tags on the 'Advanced' screen).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-03-2014, 09:54 AM
lucky16 lucky16 is offline How to Link an excel cell to word using Quickparts? Windows 7 32bit How to Link an excel cell to word using Quickparts? Office 2007
Novice
How to Link an excel cell to word using Quickparts?
 
Join Date: Jan 2014
Posts: 21
lucky16 is on a distinguished road
Default

Hi,

I am not using any code. I just copied a cell from excel then using paste special>unformatted text in word doc.

Thanks,
Have a Nice Day.
Reply With Quote
  #4  
Old 10-03-2014, 02:14 PM
macropod's Avatar
macropod macropod is offline How to Link an excel cell to word using Quickparts? Windows 7 64bit How to Link an excel cell to word using Quickparts? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
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

Did you check the 'paste link' option when doing the paste special?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 10-05-2014, 01:17 AM
lucky16 lucky16 is offline How to Link an excel cell to word using Quickparts? Windows 7 32bit How to Link an excel cell to word using Quickparts? Office 2007
Novice
How to Link an excel cell to word using Quickparts?
 
Join Date: Jan 2014
Posts: 21
lucky16 is on a distinguished road
Default

Yes. I have selected paste link then clicked unformatted text.
I'm not sure, but Quick parts in word seem to be useful. Can we link a cell using quick parts.

Thanks
Have a nice day!
Reply With Quote
  #6  
Old 10-05-2014, 01:30 AM
macropod's Avatar
macropod macropod is offline How to Link an excel cell to word using Quickparts? Windows 7 64bit How to Link an excel cell to word using Quickparts? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
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

Well, you could create a custom quick part containing the link, but I fail to see how this would be much use - the quick part would always be coded to that specific link.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 10-05-2014, 01:47 AM
lucky16 lucky16 is offline How to Link an excel cell to word using Quickparts? Windows 7 32bit How to Link an excel cell to word using Quickparts? Office 2007
Novice
How to Link an excel cell to word using Quickparts?
 
Join Date: Jan 2014
Posts: 21
lucky16 is on a distinguished road
Default

Ok. Can you please suggest the method to link the cell to word.

Thanks
Have a nice day!
Reply With Quote
  #8  
Old 10-05-2014, 02:36 AM
macropod's Avatar
macropod macropod is offline How to Link an excel cell to word using Quickparts? Windows 7 64bit How to Link an excel cell to word using Quickparts? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
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

That's done by copying the cell, then pasting into Word using Paste Special, with the 'paste link' option. However, without knowing what you're wanting to achieve beyond that basic aspect, there's little more I could add.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 10-05-2014, 05:22 AM
lucky16 lucky16 is offline How to Link an excel cell to word using Quickparts? Windows 7 32bit How to Link an excel cell to word using Quickparts? Office 2007
Novice
How to Link an excel cell to word using Quickparts?
 
Join Date: Jan 2014
Posts: 21
lucky16 is on a distinguished road
Default

Thank you for replying.
In one cell of my excel sheet there exists customer name which gets updated from time to time. And i need to enter the same customer name in a word document. So i'm trying to link the cell to word. I just used the above method (paste special>Paste link). But, When i close and reopen the word document i don't see the update link option in context menu. Further it says "This object is corrupt or is no longer available".

Both the excel file and word document are macro enabled documents. I suspected this could be the reason, for word not updating the link. So i saved the word macro enabled document in regular format of word 97-2003 document. Then i see the link working as intended. Though i found solution, this will not help as my word document contains content that needs macros enabled.
Other things which i ensured to make the link work properly is placing both documents in same folder.
Hence i was asking about quickparts as the above method is not working.

Any help or suggestion will be valuable for me.

Thanks.
Reply With Quote
  #10  
Old 10-05-2014, 08:39 AM
macropod's Avatar
macropod macropod is offline How to Link an excel cell to word using Quickparts? Windows 7 64bit How to Link an excel cell to word using Quickparts? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
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

See: http://support2.microsoft.com/kb/961244
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 10-09-2014, 10:20 AM
lucky16 lucky16 is offline How to Link an excel cell to word using Quickparts? Windows 7 32bit How to Link an excel cell to word using Quickparts? Office 2007
Novice
How to Link an excel cell to word using Quickparts?
 
Join Date: Jan 2014
Posts: 21
lucky16 is on a distinguished road
Default

Above link was helpful.

Thank you! very much.
Reply With Quote
Reply

Tags
linked objects, linked values, word 2007



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Link an excel cell to word using Quickparts? Excel Link in word chandan56 Office 3 07-02-2015 07:07 PM
How to Link an excel cell to word using Quickparts? Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? bharathkumarst Excel 7 10-13-2014 10:25 AM
How to Link an excel cell to word using Quickparts? An html link from Excel works, but now there is too much extra space in the cell njweatherdon Word 2 09-22-2014 09:06 PM
How to Link an excel cell to word using Quickparts? MS Word and Excel Data Link MDBeets Word 7 03-31-2014 02:23 PM
link excel to word ganeshm Office 1 03-27-2013 01:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:09 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