Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
paste special link
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
paste special link
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 Microsoft Word MVP "Nav" wrote in message ... 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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
paste special link
Thank you - works like a charm.
"Stefan Blom" wrote: 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 Microsoft Word MVP "Nav" wrote in message ... 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 |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
paste special link
You are welcome.
-- Stefan Blom Microsoft Word MVP "Nav" wrote in message ... Thank you - works like a charm. "Stefan Blom" wrote: 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 Microsoft Word MVP "Nav" wrote in message ... 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 |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
paste special link
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 "Stefan Blom" wrote: You are welcome. -- Stefan Blom Microsoft Word MVP "Nav" wrote in message ... Thank you - works like a charm. "Stefan Blom" wrote: 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 Microsoft Word MVP "Nav" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is Past link inactive in the dialog Paste Special? | Microsoft Word Help | |||
Paste Special | Microsoft Word Help | |||
paste special | Page Layout | |||
Where can I find the old "Paste Special" (Edit/Paste Special)? | Microsoft Word Help | |||
What is the difference in using 'paste' and 'paste special'? | Microsoft Word Help |