paste special link

[Nav]

Hello

I use Paste Special link as bitmap from Excel to Word (V. 2003 SP2).
However sometimes I have to add an addition row in Excel and when I update
the link the Word the last row is removed.

Is there a way in word where I am able to edit the range that the link is
referencing without deleting and having to copy and paste special the link
again.

All ideas/help is appreciated.

Regards,
Nav

 

[Stefan Blom]

Press Alt+F9 to show field codes. You will see something like this:

{ LINK Excel.Sheet.8 "C:\\Documents and
Settings\\sb\\Desktop\\test.xls" "Sheet1!R1C1:R2C2" \a \b }

You can change the specified range that the field refers to, by editing the
row and column numbers indicated in the field code (in my example above,
R1C1:R2C2 means the range starting with the cell in the first column of the
first row and ending with the cell in the second column of the second row).

When you are done, press F9 to update the field, and then press Alt+F9 again
to hide field codes.

 

[Nav]

Thank you - works like a charm.

Press Alt+F9 to show field codes. You will see something like this:

{ LINK Excel.Sheet.8 "C:\\Documents and
Settings\\sb\\Desktop\\test.xls" "Sheet1!R1C1:R2C2" \a \b }

You can change the specified range that the field refers to, by editing the
row and column numbers indicated in the field code (in my example above,
R1C1:R2C2 means the range starting with the cell in the first column of the
first row and ending with the cell in the second column of the second row).

When you are done, press F9 to update the field, and then press Alt+F9 again
to hide field codes.

 

[Stefan Blom]

You are welcome.

 

[Nav]

Hello

I have another question if anyone is able to help.
I have a word doc - but it has 20+ links in the links Links Information
(Edit - Links), but only has 3 bitmaps as the others have been deleted. Is
there any way to have Word remove the links that are no longer linked to any
bitmaps? Or an easy way to find out which ones are currently valid. I wish
to remove these as it is slowing the file down.

Thank you again,
Nav