S
stan clark
I can't quite figure out how to solve this... so here goes...
I'm making a report template in Word that has several links to an Exce
spreadsheet. When finished, I would like to reuse this combinatio
(make copies of both files) while maintaining the links (ie: copy o
"word 1" should be linked to copy of "excel 1", not original "excel 1"
However, if I simply copy the files, the Excel file is not linked t
anything and the Word file maintains the links to the original Exce
spreadsheet. Does anyone know how to solve this?? Thanks for you
help.
FYI - I tried recording a macro to update the links automatically, bu
that doesn't appear to work. Does anyone copy/reuse their linke
Word/Excel spreadsheets? I know there's got to be an easier way tha
going through each time and updating the links manually! Thanks
I'm making a report template in Word that has several links to an Exce
spreadsheet. When finished, I would like to reuse this combinatio
(make copies of both files) while maintaining the links (ie: copy o
"word 1" should be linked to copy of "excel 1", not original "excel 1"
However, if I simply copy the files, the Excel file is not linked t
anything and the Word file maintains the links to the original Exce
spreadsheet. Does anyone know how to solve this?? Thanks for you
help.
FYI - I tried recording a macro to update the links automatically, bu
that doesn't appear to work. Does anyone copy/reuse their linke
Word/Excel spreadsheets? I know there's got to be an easier way tha
going through each time and updating the links manually! Thanks