Link from Word to an Excel cell.

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I'm using Word and Excel 2000.

Is it possible to link from Word to an Excel cell?

I want to have the data automatically updated in Word

Whenever the data changes in Excel.

Example: The color of the cat is blue.

The word blue would come from the Excel cell A1.

The word blue would change id the value in cell A1 changed.

Help please.

Thanks.
 
Richard,

Try copying the cell in Excel and then Paste Special with the link activated
in Word.
 
Hi Richard,
Is it possible to link from Word to an Excel cell?

I want to have the data automatically updated in Word
Click to expand...
Greg's reply is correct, but I'd like to add something to
it:

The newest security patches and SP updates turn automatic
link updating off by default. In order to reenable it, see:

http://support.microsoft.com?kbid=330079
WD: How the Behavior of the Word Fields Changes After You
Install the Word Update

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
Back
Top