Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Paste link problem
I am using the paste link function to link excel schedules. The problem I
have is that when I insert a row in excel, it messes up all my paste links. So if I am linking to cell F5, and then I insert a row (making the data in F5 shift down to G5), the word document still links to F5 instead of G5. Is there a way to fix this? |
#2
|
|||
|
|||
What happens if you assign names to a range
of cells in your Excel table then link to the named range? ========== "yoyoyooreo" wrote in message ... I am using the paste link function to link excel schedules. The problem I have is that when I insert a row in excel, it messes up all my paste links. So if I am linking to cell F5, and then I insert a row (making the data in F5 shift down to G5), the word document still links to F5 instead of G5. Is there a way to fix this? -- Bob Buckland ?:-) MS Office System Products MVP *Courtesy is not expensive and can pay big dividends* |
#3
|
|||
|
|||
Hello-
AFAIK, what you are asking cannot be done. Links point to a location in the source file, not to specific content. In order for it to work the way you want, the link would have to remember what it was looking for, where it used to be, where it is now and what distinguishes it from identical content stored elswhere in the workbook. There may be other approaches to your intended result if you share more about what you want to accomplish. Regards |:) "yoyoyooreo" wrote: I am using the paste link function to link excel schedules. The problem I have is that when I insert a row in excel, it messes up all my paste links. So if I am linking to cell F5, and then I insert a row (making the data in F5 shift down to G5), the word document still links to F5 instead of G5. Is there a way to fix this? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is Past link inactive in the dialog Paste Special? | Microsoft Word Help | |||
Cut and Paste Problem | Microsoft Word Help | |||
Excel Paste Link - Insert row problem | Microsoft Word Help | |||
Copy Word Table and Paste Link in Datasheet of MS Graph Object | Tables | |||
Link to Excel (Formatting Problem) | Microsoft Word Help |