Linked Excel in Word document

[Gavona]

Simple question: My Word2000 document currently contains a table that is in fact a linked spreadsheet. Currently A1:F17 is linked. I want to extend the linked range to A1:F18 but I can't seem to work out how to do it.

All help gratefully rec'd.

Thanks,

Gavin

 

[sawedoff]

The easiest way may be to simply delete what is there, and re-paste the new link in. Just go to the worksheet and select the part you want linked, copy, then paste special >paste link into the word document where the old lik used to be.

Sawedoff

 

[Gavona]

Thanks Sawedoff, of course that works. I just thought that there must we a better way, and I guess was hoping for a clue to understanding links better and solving the real problem. (I should have posted that really!)

Anyhow I think I have now solved but in case it helps anyone else:

Problem: user inserts a row in the middle of the linked excel range. Word does not automatically adjust the number of rows in the link and so drops the last row. That this has happened is missed and the document goes out with a crucial bit of info missing.

Two solutions:
Solution1:
In word you can use Edit,Links,ChangeSource
Confirm the same source file as before but modify (extend)the range (which for me is in R1C1 format)
That extends the range but does not resolve the underlying problem.

Solution2 - the best:
Step1 In the Excel workbook give the range you want linked a name:
Select the cells,
click the name box at left end of formula bar,
type the name for the cells (say "Table1"),
press enter
save the workbook

Step2a - to change an existing link (probably easier though to create link afresh as per step2b)
In Word
Select the link using Edit,Links,ChangeSource
In the 'Item' box change from Sheet1!R4C2:R7C3 to Sheet1!Table1
Press Open

Step2b - to make a new link
In excel select the (named) Range, then Copy
In word use PasteSpecial, Pastelink
I found this caused word to automatically use the named range rather than RC references.

The linked area will now always be the named range - even if changes to the spreadsheet were made while the word document was closed.


Thanks,

Gavin