Linking text from an embedded sreadsheet cell

spheon · #1 05-25-2011, 10:09 AM

Hi Everyone

I hope someone can help me...

I have an embedded spreadsheet in a word document and I want to be able to copy the contents of a cell into another part of the document (within a table) whereby it will automatically update when the spreadsheet is updated.

Can anyone explain how to do this please (if possible)

thanks greatly

Sph

macropod · #2 05-26-2011, 12:54 AM

Hi sph,

In theory, you should be able to do this by copying the cell, then using Paste Special with the 'Paste Link' option. In practice, it seems the links often don't work properly (at least, not in previous Word versions). Your purpose might be better served by having an external Excel workbook and linking the relevant cells from that to both locations in your Word document - this does work reliably.

spheon · #3 05-26-2011, 01:03 PM

Thank you now sorted

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linking an image that is not embedded	charismarl	Word	1	02-25-2011 01:58 AM
Linking text between worksheets	AndrewsGram	Excel	1	03-09-2010 01:26 PM
Finding a text style in a cell	jimbassett	Excel	1	02-10-2010 08:39 PM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM
Linking Text Fields in a document in Word 2007	lcolson	Word	0	12-22-2008 05:14 AM