How do I reference a cell in an embeded Excel object?

[Kinely]

I have office 2000. I have an excel spreadsheet that I put in MS Word as an
object. (that is: from the insert menu I selected "Object" and "Create from
file" then picked my spreadsheet.) Now I am trying to put a Field in Word
that will look up info on my spreadsheet. I am able to do this with the
spreadsheet as a seperate file, but I want to have the spreadsheet in my word
doc to make it as easy as possible for the end user. Any help would be great.

 

[CyberTaz]

I don't know whether this will work in 2000 or not but one simple option to
try is:

Double-click the Excel object in your doc, then select & copy the cell.

Go back to the desired location in the do, use Edit> Paste Special -
Unformatted Text & check the Link box.