View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gboll gboll is offline
external usenet poster
 
Posts: 6
Default Excel link with Word

no, that brings in the entire worksheet

I have a file in excel that has all the prices like:
15900
16500
12300
etc

then the word document I have is this:

Basic Widget
Model............................................. ...........................
XXXXX

Where the XXXXX is I would like to link to the spreadsheet so that the 16500
number is linked or embedded into the word document.

Then if I change all the prices it automatically updates my price book

"ryguy7272" wrote:

Insert object Create from file Browse ...choose the spreadhsheet that
you want to link to... Insert

Does that do what you want?

Regards,
Ryan---

--
RyGuy


"gboll" wrote:

I am creating a file that is like a menu that has descriptions in word and
then I was hoping to put field link in word to tie to a spreadsheet that I
could update the prices. How would I create the links in the word document
to take the info from my excel file?